-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Conditionally Formatting Children
I am using Conditional Formatting to change the background color of a row based on the value of a cell in that row. I want to visually distinguish courses on a course development list belonging to certain colleges. FOR EXAMPLE If College="UC", color background yellow. If College="PS", color background light blue. I am…
-
Conditional Formatting and Checkboxes
Is there a way to set conditional formatting on a checkbox column so that if text is entered in one column, the checkbox in another column is automatically checked?
-
Replicating an Annual Schedule Worksheet
I am trying to replicate annual pre planned maintenance schedule worksheets eg. copying 2018 and creating a 2019 worksheet. I have done so by opening my 2018 worksheet and 'saving as new' renaming to 2019 then deleting all the 2018 data. I just noticed the conditional formatting based on dates is still set to 2018 so I…
-
Single-Use Checkbox (or dropdown) - Can it be done?
Hi all! I looked in the forums and I didn't come upon any which matched this - but if you're aware of a similar thread, please link to it here! We are looking to find a way to make a checkbox or dropdown option a single-use type thing. Basically - we track travel in a large sheet - and part of the information we collect…
-
Conditional formatting in Calendar View
Is there a way to extend conditional formatting to Calendar View? I did notice that if you click on an individual item you can change to desired color. But my project extends over 2FYs and has over 1000 items, so individual formatting is not an option. Thank you.
-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
New Features in Smartsheet
Hello Community, We recently updated Smartsheet to include some new helpful features. This update is centered around formatting improvements, and a way to give ownership of your sheets to other licensed Smartsheet users. Here's a breakdown of the updates: * You can now double-click on the Format Painter button to "lock" it…
-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
