I use the following to surface data to illustrate submissions over time over a set period of time (set start and end date). This uses a metric sheet with the dates in one column and a function adjacen…
Help please! I'm looking for the invoice amounts from one sheet transfer into another sheet based on a matching CAR#. For example: if CAR# FP2020-1 is listed in spreadsheet (B) then I want the invoice…
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…