-
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…
-
Total % Complete for 4 columns
I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…
-
Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
