-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Formula to sort by date based on another criteria
Hello I am looking for a formula that will tell me how many times a certain criteria comes up per month. We have a quote log that has different stages and we need to know how many of each type of quote stage exist per each month. In the attached screenshot I need to know how many quotes were "Develop" in the quote stage…
-
Prevent Formula Overriding
Hi there! I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. The issue I'm having is that the formula erases if someone…
-
Reference Another Sheet Ranges Shifting
I have a metrics sheet built out referencing a master sheet. The master sheet is a running tracker and each month we add new rows to it. Any time we do this, it shifts my reference ranges on my metrics sheet. We've tried adding new rows to the very bottom of the master sheet as well as inserting the new rows between…
-
CountIF using AND
Hi all, Can anyone tell me what might be wrong with this function below? =COUNTIF((AND([Field CSA]:[Field CSA],"Name"),([Status]:[Status],"TEMP"))) I need to count the occurrences where the Field CSA column has the word Name and where the status column has the word TEMP. When each value appears in their respective columns…
-
Flag By Date Column 6 Weeks or Greater in the Past
Hi, We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete" What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? Thank you so much in advance! Jared
-
Email automation based on time.
We cannot set automated reminders after minutes. Our need: Send email if row has not been modified within 30 minutes of created. We also can't calculate in minutes with a formula? Just seems like a huge oversight.
-
Sum of Parent plus Children
Is there a way to get the parent row to indluce sum of parent plus children? We use a JIRA connector, and the team bills hours to the parent or Epic, as well as the Stories and Tasks with that Epic Link. As another screwball, JIRA reports time in minutes, so I have to convert Time Spent to Actual Hours by dividing by 60,…
-
Fill sheet based on another sheet (if cells contain value)
Hi Smartsheet community, I am looking for formulas or ways to automatically fill sheet B with the information of certain columns of sheet A for all rows in sheet A that contain a value. In a dynamic way, meaning if a row is added to sheet A it should be also added to sheet B. For example: - Sheet A has 1 column with 10…
-
Formula reference data exceeding 25k cells
Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this