-
Formulas in sheets with auto-number columns
I have a sheet with an automatic numbering column. Data for this sheet will be captured through a webform. I need certain columns, which will not be populated throught the webform, to have formulas in them. How do I add those formulas without adding them in the first row which triggers the automatic numbering? I thought of…
-
Flag Formula
Hello I would like to make the flag red if 2 criteria are met % Column is under 80% AND Deadline is within the next 2 days? IF(AND(% Column)@row), <80%, (Deadline)? I'm stuck on the second half of the formula can anyone help? Many thanks
-
Creating automations and the dropdown list for contacts is incorrect
I have email addresses that are wrong in the automation. My contact list is defined and only is accepting the prescribed values. I would like to remove the ones from the automation if possible so folks don't inadvertently select the wrong contact. Anyone else come across this?
-
COUNTIF(S) where items are NOT equal to more than one value
Hello! I am trying to create a formula which counts all items that are NOT assigned to a list of about 8 people. These will be totaled into an "Other" field. Example: PMs include Bob, Sarah, Dee, David, and George. I have counts for how many projects are assigned to each of these people, no problem. Then I have a bunch of…
-
Smartsheet re-opening automatically after hitting submit
Is there a feature that would allow a SmartSheet form to automatically re-open with a new form after hitting submit? we are using a form for each caller and it is cumbersome to hit submit and then find/click the link to open a new form.
-
I need help completing an If statement to calculate networkdays when a condition is met
I have the need to calculate the amount of days a record was open or is currently open. I keep getting errors in the formula. I have the below screen shot for reference. So, when Progress tracking = complete I need the networkdays from Created to Completed and when Progress tracking <> complete I need the networkdays from…
-
Auto fill dates
I just uploaded a excel sheet into smarthsheet that was tracking the date when data was inputted since 3-23-20. I created a new form that the user didn't want the date to appear on and a column with auto fill date when created. This doesn't really work with old inputted data bc you cant edit the auto fill cells . So the…
-
countif: Each project has an ID, but i need to see a warning when we put a same ID number or text
I need to compare on ID cell values. Each project have an ID, but i need to see a warning when we put a same ID number or text, then we need to fix this new row below to the orginal project row, thanks for your help johann
-
Converting from feet and inches to inches
Hi All, I need to convert from feet and inches (5' 4") to inches only in smartsheet. I have tried using =LEFT(Width3,FIND("'",Width3)-1)*12+SUBSTITUTE(MID(Width3,FIND("'",Width3)+1,LEN(Width3)),"""","") =LEFT(Width3, FIND("'",Width3)-1)*12 + MID(Width3,FIND("'",Width3)+1,LEN(Width3)-FIND("'",Width3)-1) =IF(ISBLANK(Width3),…
-
Capture metric each day and add to new row
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it? Example of metrics I'm collecting on-the-fly from Control…
