-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if a…
-
How to combine multiple IF statements into one?
Hello! I have 3 different IF statements in 3 separate columns that I would like combined into 1 if possible. The three IF statements/columns are the following: Red Status - if task is in the past and not checked complete: =IF(AND([End Date]@row < [Today Helper]@row, [Task Complete?]@row = 0), "Red", "Green")=IF(AND([End…
-
Calculate Date based on Criteria in Two Cells
I need to write a formula to check a cell for a size (Small, Medium, or Large) and calculate a start date from a go-live date in another cell. If the size is small, it's 14 days earlier, if it is medium, it is 21 days earlier and if large 28 days earlier. I've go this as my starting point: =IF([Size]@row,…
-
Can I setup conditional formatting based on a time function?
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
-
Workflow - recognising email domain as part of "assigned to" column
Hi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "firtstname.lastname@smartsheets.com". However in the field it would show up as "firstname lastname" without the domain at the end Company - dropdown box with 2 company…
-
Adding hours to a date
Hello, I have the following columns in a sheet: "Created (Date)" records the date/time a form was submitted. "Modified (Date)" records the date/time a row is copied to the final sheet in my workflow. I want to compare the modified date to another date that is manually entered in the row to determine when to send a…
-
Help with Max/Collect Function
Hello! For my project, I have a database of task cards. Information for these task cards (such as Date updated, status, labor hours per skill set, etc) is input into a separate sheet, which is collected and fed into my main database. Currently, I have a helper column that says "Is this the most recent row updated for this…
-
Nested ISDATE error
Hi - I am trying to count the NETWORKDAYS between [Date Assigned] and [Date Complete] if [Date Complete] is a date, otherwise to calculate NETWORKDAYS between [Date Assigned] and TODAY() using this formula but get an argument error. Looking for help! =IF(ISDATE([Date Complete]@row, NETWORKDAYS([Date Assigned]@row, [Date…
-
If formula with nested AND, OR, NOT ISBLANK within
Not sure what I did wrong as when I'm reading through the formulat i wrote it seems correct, but I'm not getting the correct color value. Essentially I need: if the status is "Not Started" OR "In Process" OR blank AND the "End Date" is not blank OR is less than today's date, turn red. If the "End Date" is blank=Gray",…
-
CountIF Formula Help for Dashboard
See screenshot. I want to create a graph on a dashboard that shows how many total rows on the sheet pertain to Medical, Fire, and/or Police (indicated by checkbox columns on each row). Will I need to create an Agency Name sub row for each Medical, Fire, and/or Police I want to be represented on the graph for the COUNTIF…