-
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…
-
How to automatically # rows with a formula?
I had a column which uses a formula referencing the value of the row below it and then add one. For example the row 2 value is [Opp Num]3 + 1. This formula automatically carried to any new entries for months allowing for continuous unique numbering of new rows. Recently this formula has not been working as intended as it…
-
Autopopulate Date based on Column
Hi, Looking for the formula that will automatically put the date when a column is checked "yes". It needs to be the date that the column changed to "yes", not todays date (as that will keep updating as days go on). When the column "Sent to Payroll" changes to yes, I want the date that it changed to "yes" to show in "Date…
-
Cross Project Dependencies
Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio: Vanilla…
-
If/Index/Collect Across two sheets
I'm getting an invalid value error but I'm not sure why with the following formula: =IF([Journal Source]@row = "Supplier Invoice", INDEX(COLLECT({Forecast Sheet Row Number}, {Forecast Sheet Supplier}, Supplier@row, {Forecast Sheet Month}, [2023 Month]@row), 1)) Referenced Sheet: Original Sheet (With Formula in the matching…
