-
Formula to check a box if it meets multiple criteria in another sheet
Hi! I have two sheets: Sheet A: ID#, Date, and a checkbox Sheet B: ID#, Date Can someone please tell me what should the formula be if I want to Sheet A checkbox to check if Sheet A's ID# and Date match with Sheet B's ID# and Date. I tried a few different formula and it seems like it doesn't work: =IF(AND(MATCH([ID #]@row,…
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.…
-
How do I set several cell values to a specific value in a different column
Hi, I am running into issue and I cannot think about a way to solve it. I have a column (Drop-down list) containing specific statuses (Status Column) which I need to match to 5 different report statuses (Not Started, In Flight, On Hold, Cancelled, Completed). The match is as follow: I can match the "Not Started" and "In…
-
RAG status based on dates overdue
Hi, I'm attempting to get an output of either, "On Track", "Overdue" or "Critically Overdue" for baseline milestone dates in Smartsheet, with the Overdue being 5 days over & Critically overdue being 20 days over respectively. I have drafted the initial IF statement, however i'm suck on how to add the additional "Critically…
-
Date Overlapping Formula with Same Resources
Hi Smarties, I am working on a challenge below hoping for some help. I would like to raise a flag (on a flag column), if Start Date and End Date of a project conflict with other Start Date and End Date. Projects are the ones with Header "0" Only if the Start Date and End Date of the projects are assigned to the same…
-
Cell History Changing Due to Time Zone for Column Formula?
Hi, I have a column level formula and the oddest thing is happening. My cell value keeps changing to a swapping date when the actual cell containing the date has not changed (cell history checked). I'm hunching that a user is using different timezone date format which is why the dates flip between MM/DD and DD/MM and back…
-
Forms or Formulas with appointment scheduling
Hello All! hope you can assist. Trying to have a form (external users fill out) to book a time slot - Once that time is gone - no longer available to anyone else and thus is removed from the options. Is there a solution, formula or best way to achieve this without using a third party booking tool? 🤔 Thanks Trish😀
-
Copy a date to a cell only if there is not already a date there
I'm trying to capture a date from a cell to another cell only if the current cell is blank Here is what I have so far: =IF(ISBLANK([Proposed PROD Release Date]@row), "", IF(ISDATE([Proposed PROD Release Date]@row), [Proposed PROD Release Date]@row)) This formula is in [New date] cell but I only want this to occur if new…
-
Smartsheets not staying saved.
Hi, I have a smartsheets that has a formula in that works out the number of days between a date and todays date. Therefore every day the No. days goes up and I have a dashboard off of this. The issue is that when the formula changes the No. days I have to manually go into the sheet and click save for it to get to the…
-
Index Collect Looking at Auto Number Column
I have an index collect statement in one sheet that uses a column with an auto number value in another table. I get an invalid value error with the formula. However, if I change the column type to text/number from auto number it works.