-
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.
-
How to count cells with a value in a column
Hello, Trying to figure out how to count cells with values in one column. For example: I want to know how many cells contain a value on the following: Column 2 Josh Robert Alexandra Greg My ideal answer would be that there are 4 values in column 2. Any idea what the formula is for this? I have the formula for blank cells:…
-
Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?
SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the leadership team. Challenge: Cross sheet formula (below) pulls correct data but when…