-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Best way to connect Smartsheets to other sheets
Hi Everyone, I’m looking for best practice recommendations for managing multiple Smartsheets that are connected across different projects and management reporting needs. Currently, I have several sheets linked together using formulas, which works, but I’m wondering if there is a more efficient or scalable approach. The…
-
Formula to update a column based on if a date is blank or in the future
=IF([Grant Status]@row = "Inactive", "", IF([End Date]@row = "", IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4)), IF(TODAY() >= [End Date]@row - 90, 5, IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4))))) This formula has worked well but I need to update so that…
-
IF/ OR Function
Created a formula to send an email to john doe if AMER or EMEA or APAC is selected in georgraphical region and send email to Jane Doe only if EMEA is selected and send emial to Bill doe only if APAC is selected. See formula below. I'm receiving column forumla syntax error. =IF(OR([Geographical Region]@row = "AMER", "EMEA",…
-
Need help witha most recent date coulmn
I have two sheets that have test results Oil PF(1) and Oil PF(2), I have made helper columns for both of them using =MAX(COLLECT({Oil PF(1)-Date}, {Oil PF(1)-Circuit-ID}, [CB Identifier]@row)) for both respectively. they only return blanks, and I cant figure out what is going wrong.
-
If date field is blank formula
Currently, I have this column formula and it works well. =IF([Grant Status]@row = "Inactive", "", IF([End Date]@row = "", IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4)), IF(TODAY() >= [End Date]@row - 90, 5, IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4)))))…
-
Bridge
Hello, I've set up Bridge, and it's working as expected: when a task is created, it is automatically moved under its parent task without any manual intervention. However, there is a short delay of around one to two minutes before the row is indented under the parent task in the main sheet🤔 Is it normal for the…
-
Looking for data in all the sheets
Hello, I am new to smartsheets and I have go through the on-line training. I am well versed in excel so I have some knowledge of spreadsheets. One thing I am perplexed on in smartsheets is I can't seem to find a formula to search all the sheets and then return a value to sum. I have used the SUMIF and pointed to a cell to…
-
Workflow keeps deactivating (“workflow became invalid” email) but nothing looks broken and the activity log shows no disable entry
I have a workflow that keeps deactivating itself. Each time I get a “workflow became invalid” email, but when I open the workflow nothing looks broken. I have to turn it back on manually. It then works for a while and deactivates again. The activity log shows no entry for the deactivation. I think there is a correlation to…
-
Connections / Manage Workflows - turned off?
Why did Smartsheet 'stop or disconnect' the ability to launch workflows applicable to a given sheet using 'Connections / Manage Workflows' ?