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 …
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 s…
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…
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…
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…
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 t…
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…
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…
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 Stat…
