-
Can I save the settings for an update request?
I have a sheet with many columns When I send an update request most of the columns dont apply (they are for later in the process). This means I have to edit the uodae request and untick the columns I do not want to send. Is there a way to save the settings (unticked columns) for subsequent update requests from the same…
-
Total Site % Complete + health
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…
-
TOTAL% COLUMN
-
How to overrule a 0 multiplication formula returning 0 as an answer?
Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…
-
Countifs and the use of OR
I am currently using the Countifs function to count the number of "Yes" responses to several questions that are asked using a SmartSheet Form. Some of the questions are designed in a way that does not capture anything creating an empty field in the question for a particular row. I need to be able to count "empty" fields as…
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
-
Can I keep grouped reports colapsed?
I have a grouped report below that I expand to update individual sheets. However when I return to the report each all are expanded that I have close again to scroll down more easily!. Is there a way to keep it collapsed?
-
Disable Form Submission
Hi all, I am trying to create a form where people need to make requests by 10 out days or more. The form will be continual, year-round, so I can't just take down the form or put a due date, since this form request is never ending. Is there a way for me to set a condition that if you're within a certain range (i.e. less…
-
Task Health
I am having hard time to have a formula to obtain the health color for the task I have 3 columns: End Date, Circuit Quote% Status and Quote Health IF(AND( [Circuit Quote % Status]@row <=0.5, [End Date]@row <= Today (7)), “Red” IF(AND([Circuit Quote % Status]@row >=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…
-
TASK % COMPLETE FORMULA
I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…