We have a sheet that automatically generates a job number based on how someone fills out a web form: =IF([CLIENT - REGION]1 = "HMA - Hyundai Motor America", "HMA", IF([CLIENT - REGION]1 = "HDAA - Hyun…
I'm trying to look at all my formulas and am wondering if anyone knows of a way to (temporarily) highlight or identify every cell in a sheet that has any kind of formula in it.
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to creat…
I thought I had written an enhancement request for this before, but I have no record of it. I'd like to be able to retrieve the row number (not the ID, the number) using a formula. Some use cases: In …
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s…
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the To…
Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form departmen…
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the f…