-
How to make my automated email only send once?
Hello! I am going to explain as best I can. So i have a automated system setup and currently i have where they fill out a form and it then auto creates a Fillable PDF. That gets sent to them which they have to get signed and re submit it into smart sheet. I have it set up where it send an alert which has the PDF and then a…
-
How to remove NA from Calculation
Hello, I am currently using the formula below to get a percentage complete calculation, one of the parameters has the option for NA. How do I include the NA in the formula to make it so it doesn't affect the percentage? It is the bolded parameter below: =SUM(IF([Paperwork Received]1 = "YES", 0.2, 0), IF([Samples Received]1…
-
COUNTIF or COUNTIFS to sum blank fields
I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been able to get a formula to work when trying to account (and not count) for the helper columns (in this example column 11 and…
-
Expense Sum Formula
I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today. I have tried many variations of the following and it's still Unparsable. I've also tried adding @cell. What am I missing? =SUMIF([Event Title]:[Event Title], "MS CI…
-
Count Column if cell does not contain
I am working on a sheet summary formula. The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not reading "Complete" in the summary. The formula for that column will return a numerical value for other rows, based on how many…
-
Long formula for Status balls with 2 criteria
I have a tracker that needs a Status column using Harvey balls. There are columns for 6 mon, 12 mon, and 24 mon MIN and MAX and Completed Visit scheduling dates, and the Project Manager is asking for a Status column that will show whether there is a visit past due, coming up, or completed based on the colored balls. (I…
-
Invoice generation for multiple line items
Is there a way work around to generate one invoice for multiple line (example 10-20 items). I tried document builder but we can be able to generate one invoice in the row level.
-
Formula for Smartsheet PMO Template Project Plan Schedule Health
I have set up a Schedule Health Formula in the Project Plan where it calculates the Schedule Health based on the Health of the Children Rows. For Example, if 1 of the 6 Children Rows(Level 2) is Red then the Parent Row(Level 1) is Yellow and if there are 2 or more Children row(Level 2) are Red then the Parent Row(Level 1)…
-
How you calculate the difference for the weeknumber of a date and todays date, considering the year?
I have a project schedule where we use =IFERROR(WEEKNUMBER([End Date]@row) - WEEKNUMBER(TODAY()), "") to calculate how far away the week number of the End Date is from the week number of Today's date. We have End Date's that are from Today's date just a year ago causing them to calculate a 0 as if the row item's End Date…
-
Why do the dates change in the fillable PDF?
Hello I am making fillable PDF and I was trying to put a birthday in them and when it loaded it came out as (Not real) 04/05/23. I have changed it in the smart sheet cells where the dates read out as April 5, 2023 but when it hits the fillable PDF it changes to just numbers. I need it to be spelled out does anyone know why…