I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in Ma…
I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is the…
I am trying to write the following logic to calculate the SLA breach. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day. However, …
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would form…
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sh…
=INDEX(COLLECT({Unit/Manager List WI Range 1}, {Unit/Manager List WI Range 7}, [Area of Study Parent]@row, {Unit/Manager List WI Range 8}, [Area of Study - Nursing]@row, {Unit/Manager List WI Range 9}…
I have a sheet that contains book information and want to index/match date from another Smartsheet as long as the date in the column called Most Recent Available Date@row is greater than today AND Inv…
I would like to count how many people scored between 99.5 and 99.9. Here is my formual. =COUNTIFS(Janury2:January12; >=99.5; January2:January13; <=99.9)
I need to find cells that match each other on 2 sheets and display them on a 3rd sheet, but the displayed cells have to be in the last 14 days of a date column on one of the original 2 sheets.
I'm attempting to use Row@row along with an Auto Number column, in a column formula, so I don't have to manually update the formula when rows move within the sheet, but am not having any luck. The for…