-
How to convert date text to date in another cell?
I have a field that contains text date and I need to convert it to a date in another cell. The format of the text date is Wednesday, February 9, 2022. I need to convert it to a date in a different cell.
-
Formula based on created time foiled by users in different time zones
I created a formula that looks at the created time and date and checks a box if the hour is after a certain time if the day is a certain date. When the box gets checked, it means the entry was made late, and an approval workflow kicks off to managers to review and approve the entry. The created time deadline is CST based.…
-
Count cells from a specific row and then take an average
Hello all , What I am trying to do is look up a specific word in a column, then pull the value in the same row from another.. but then take an average of those numbers. For example: I want to know the average number of days for all CPSS, then average number of days for Internal etc.
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entries
My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple * Pear * Grapes * Banana * Other I need guidance on how to structure the criteria for…
-
Tracking Prev Wk % Complete to Current Wk % Complete in Sheet Summary fields
Hello, I'm newer to Smartsheet and trying to figure out what formulas I would enter into two Sheet Summary fields in my project plan to track 1) The previous week's overall project % complete (e.g, 45% complete as of X date) and 2) the current week % complete (e.g, 48% complete as of right now). It would also be great if I…
-
Hi, please help with the following formula to return a text status:
I am trying to return the following status updates: "Planned" if Today's date is before the Planned start date, "Late" if Today's date is after the Due date, and "In progress" if Today's date is between the Planned start date and Due date. It works for "Planned" and "Late", but as soon as I add the "In progress" part it…
-
If statement with an OR... HELP
I have looked at this for hours now. I have a cell where I want to calculate in a column [project age] in days. I have a cell for [start date] and [end date]. When I use =today() - [start date]@row, I get the right answer. I also have a [project status] cell with a drop down list of: preliminary, active, cancelled,…
-
How to have Parent field Status update according to multiple Children field Status?
Hello all, I'm relatively new to smartsheet and excel and was hoping to get some help automating part of my sheet. I also have a bad habit of going about things the most complicated way possible, so there may be a much simpler way to accomplish this. The columns involved are: Status(TBD, Complete, On Schedule, Past Due),…
-
Formula to Update Status based on Percent Complete (Column Formula with Row Heirarchy)
Please see pic. I am using this formula. How do I update it to work as a column formula and also recognize parent/child row hierarchy, please? IF([% Complete]1 = 0, "Not Started", IF([% Complete]1 = 1, "Complete", "In Progress"))
-
Setting Task Due Dates Based on Project Due Date (Retroactively)
I need to create a sheet/template where the due dates of tasks are based on the project's due date (i.e., I want to "back into" the project due date). I assume formulas or helper columns might be necessary to accomplish this (e.g., =Projectt_Due_Date-90, etc.), but I can't wrap my head around how to do this using…