-
Schedule update dates
Hi, I'm looking at creating a function that lets the user know when the next review date for a row is, based on the Overall Status (not closed), Last Review Date and Review Frequency columns. If possible I'd like to use Daily, Weekly etc., to make it a better experience for the user, rather than using the number of days…
-
Blank rows added to bottom of sheet / form
There is a group of about 10 rows that are all blank that are automatically being added to a sheet we have created. We do have an active form for this sheet for project requests. there is no information in any row listed. I have tried deleting them by right clicking and "delete row" and also the Row Actions to delete and…
-
Return Date that falls within 10 days of another date
So essentailly we have 2 sheets. On 1 sheet we have a list of test dates(call it test dates). Then on the main sheet we a column for due dates for certain documents where if not turned in Student would be locked out and can not take tests. So we want to have another column on the main sheet that pulls dates from the test…
-
How can I work around the Formula Cell Reference Limit?
Hi, I'm getting the below error message. My needs are too complicated to convert any of the formulas to automations and I'm not sure how to simplify. Here is essentially what I am trying to do - every row is a different item and columns A, B, C, and D contain fabric codes. In columns A1 and A2 (and B1, B2, C1, etc.) I need…
-
Required fields not really required on form?
Hi - I created a form with multiple required fields, but users are still able to submit the forms without the required forms being completed. They appear to be able to bypass completing the required fields and submit the form, as long as they check a required "acknowledgement" box we added at the bottom of the form. But…
-
Checking a box on all rows that meet a certain critera.
Hi, I'm in need of a formula that checks a box if the "Current Status" Column on all matching "Lab" "Number" columns that are marked as "Review Complete". For example in the screenshot below I have lab number CD722 in 4 different rows. When each of those row's "Current Status" is marked as "Review Complete" I would like…
-
Equation to Find the Second Matching Value at the Bottom of the List
On a project tracking sheet, I am trying to create a "Previous Name" column that will automatically be updated as the project names change. To do this I've been setting up an automation to copy the line to a new sheet called, "Previous Names", once that lines name is changed. The idea is to then create a equation that will…
-
If today is between a start and end date
Forgive me if this has been covered. Everything I have found has been close but not what I am trying to do. I have a sheet with visit start and end dates to populate a calendar. I want to write a formula on another sheet that adds up the total from the revenue column for every job that falls on today using the scheduled…
-
Attempting to populate the value of a cell based on the value of a different cell
So, the question posed below seemed very similar to what I'm trying to accomplish, and I did make some headway...until I started including multiple selection possibilities. I want my "Pathways" column to assign one of five values based on the value of the "Discipline" column on the same row. There are 40+ Discipline values…
-
Check box if today is between two dates and criteria is met
I am attempting to have my smartsheet check a box if one cell is marked as 23 and todays date is within a date range. I have attempted the formula below but continue to get an Incorrect Argument error =IF(COUNTIFS(FY@row, "23"), COUNTIFS(TODAY(0), >=DATE(2023, 4, 25), TODAY(0), <DATE(2023, 6, 30)), 1, 0) Does anybody know…