Αποτελέσματα Αναζήτησης
19 Οκτ 2017 · Welcome to the Smartsheet Forum Archives The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
3 Μαρ 2019 · What a GREAT way to state this... "If they both work just replace the "" at the end of the first formula with the second formula minus the = sign. Only way this would have an issue is either there is an issue with one of the formulas, or it reaches the length limit of smartsheet formulas" Was so easy to figure out once I read your comment.
1 Ιουλ 2021 · For example, ISBLANK ([Column 2]@row) will check to see if the cell is blank. Enclosing that statement within NOT (), e.g, NOT (ISBLANK ([Column 2]@row)), essentially means " [Column 2]@row is not blank". You can nest functions within other functions so long as you abide by the function's syntax (structure).
Smartsheet help articles and reference guides. Online training courses and certifications. A free library of previous webinar recordings. One-on-one coaching sessions with a Smartsheet expert. Getting Started guide, API Reference, and code snippets. Subscribe to receive emails when new features are released.
8 Μαρ 2021 · I agree with @Heather D. Try the @cell reference in the NOT function. I personally use <> which is "not equal to" in place of the NOT statement simply because of those pesky parenthesis. =SUMIFS ( {CashExpenses}, {CashExpensesMonth}, [Month or Quarter]@row, {CashExpensesCode}, [Code]@row, {CashExpensesCategory}, @cell <> "Travel") For other ...
Find answers to your Smartsheet questions in English, Deutsch, Español, Français, Italiano, Português, and 日本語. Explore webinars covering quarterly feature releases, best practices and product-specific deep dives. Share and celebrate - whether a promotion, a new Smartsheet solution, best practice or badge.
11 Ιαν 2022 · Best Answers. For an image background, you can use a .png, .gif, or .jpg file up to 5MB in size. More information on this in the link here: Customize the appearance of a form | Smartsheet Learning Center. Additionally, I found this site online thats helpful with a breakdown on sizes that falls under 5 MB.
3 Μαΐ 2022 · Ability to 'CC' someone on an autommation. Hello, I have a standard alert for when a task is marked 'Complete' to send the Owner of that task an alert. I also need the same email alert to go to two other people. In other words when the task is complete, send Owner + 2 others an alert. Where the Owner is different for each task but the 2 others ...
11 Ιαν 2022 · Then try this formula in ColumnC. We're essentially adding the result values of two formulas together: =IF (ISDATE (ColumnA@row), 0.5) + IF (ISDATE (ColumnB@row), 0.5) The logic is: If the value in the ColumnA cell on this row is a Date, set the value of this formula to .5 (otherwise do nothing,) PLUS, if the value in the ColumnB cell on this ...
4 Μαΐ 2021 · Hello all, I am trying to use the MAX/IF logic in smartsheet. It worked for me in excel: I used the same logic from above in smartsheet: And I get this:
