-
Nested IF Statement
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…
-
Average days returns 1 value if 0 and the average value if >0
I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have. =IF(AVG({Field Scheduler Test Range 1}), 0, "Same Day", (AVG({Field Scheduler Test…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Capturing the Date and Time a Cell in Smartsheet was created or modified?
How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.
-
How to Create A Template Set
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
-
Dashboard opening position
I currently have a large dashboard which is opening about 3/4 of the way down. Is it possible to set so the first view is at the top?
-
Add attachment to multiple sheets and respond?
I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert, they can attach a file. What I would like is for the attachment to be added to the…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
