-
Formula based on created time foiled by users in different time zones
I created a formula that looks at the created time and date and checks a box if the hour is after a certain time if the day is a certain date. When the box gets checked, it means the entry was made late, and an approval workflow kicks off to managers to review and approve the entry. The created time deadline is CST based.…
-
How to have Parent field Status update according to multiple Children field Status?
Hello all, I'm relatively new to smartsheet and excel and was hoping to get some help automating part of my sheet. I also have a bad habit of going about things the most complicated way possible, so there may be a much simpler way to accomplish this. The columns involved are: Status(TBD, Complete, On Schedule, Past Due),…
-
Setting Task Due Dates Based on Project Due Date (Retroactively)
I need to create a sheet/template where the due dates of tasks are based on the project's due date (i.e., I want to "back into" the project due date). I assume formulas or helper columns might be necessary to accomplish this (e.g., =Projectt_Due_Date-90, etc.), but I can't wrap my head around how to do this using…
-
Don’t know why this formula is returning #UNPARSEABLE
Hi, This is probably really basic and I’m sorry if it is, but I’ve been tearing my hair out over WHY SmartSheet is complaining about this formula: =IF(AND([Raised by]@row<>”My Name”,[Raised by]@row<>”my.name@mycompany.com”),[Raised by]@row) So - return the column “Raised by” in this row, if it’s not “My Name” and not the…
-
Countif and Sums
I am a beginner in Smartsheet and have formula phobia but have been tasked with generating metrics etc. I have an ongoing intake sheet that collects details from volunteers on how much they get paid. Some volunteers donate money back so there are several metrics I have to report on. Here are the columns I have set up. I…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…
-
Autofill a column based on another column value
I have one column set up with a dropdown menu and want another column to autofill with a specific value tied to each dropdown menu selection. Is this possible?
-
Workflow- trigger and output inconsistencies
I've built out the following workflow to notify our PMs of any newly inserted row AND change cell value on two columns in added row. The workflow is not sending notifications during my testing, but has been populating the formulas as intended when I add rows to the sheet. When I manually run the workflow and notify myself,…
-
How to combine duplicate data and sum totals of those rows.
I have a sheet that we track data for on a monthly basis for the same items (example below). I would like to display a "top impressions" and "top clicks" widget on my dashboard, but cannot figure out how to show this data without it being duplicated over the 12 times (once for each month). I know a report will need to be…
-
Count IF as a Column Formula
I have a file that gets updated daily. There is a formula to identify unique items, in this case states. The file also has a formula to look for duplicate part numbers. The issue is that if the last row is a duplicate and the end users deletes the row, then the unique items formula disappears and no longer calculates on…