-
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…
-
Reporting and Dashboarding on Multi-Select Column Type
Hi, bear with me as I am a pretty new user to Smartsheet (love the tool so far but have hit a snag) I'm currently utilizing the multi-select column type for a few of the sheets I'm working on. I love the feature, but am having trouble building the exact dashboard I need to report on my multi-select column. Let's say I have…
-
Locking Automations
We have numerous automations set up across multiple sheets, is there a way to lock these so editors/viewers aren't able to change them?
-
If Statement for Contact in another list and a flag is raised
Hello Again, I am trying to have a value populate (Which is a contact) if another contact is part of a list and a flag is raised in that same row. Some background if that wasn't clear, I have two sheets, one where employees submit if they are out of office, it has their name and the person to cover, as well as the date…