-
Can a checkbox be disabled if other checkboxes are clicked?
I have checkboxes in use for scoring to identify priority of a project. Any combination of the first four checks is fine, but checking a box in the fifth column would indicate that nothing should be checked in the first 4 columns. Currently I just have a helper column that turns red and bold if there are certain entries in…
-
IF formula for math equation?
Hello it's me again with another question... I want to create a simple formula where VALUE cell * % Complete but only when status is "in progress" So in my example, "value of % complete" colum, line 1 would say $500, and line 2 would be blank. I know there must be a way, but I can't figure it out. Blame this one on being…
-
Today() Update when rows added through Automation
The documentation for the Today() Function lists the conditions under which a formula using Today() will and will not update to the current date. TODAY Function | Smartsheet Learning Center There is no mention of what happens when rows are added to a sheet from another sheet via a MOVE or COPY automation. It does say that…
-
Formula for Health based on State only no dates
Hello, I am new to Smartsheet and I am trying to set up a basic formula for the Health using the color dots. Every formula I try is unparseable. I do not want it reading due dates right now. We are just setting this up and our due dates are work in progress. What I want is if the State Column reads the below it has…
-
Convert Date and Time to 24 Hour
What formula will help me convert date and time to 24 hour format? The column I want to convert to 24 Hour format is "Time On-Site"
-
Auto populate date from helper sheet based on certain criteria
Hi All, Having a heck of a time with a helper sheet and formula. If I type in a date, ex: 1/31/2023, I would like another column to populate a date that is before that 1/31/2022 date The kicker is I need that date to be a specific day that I have listed on a helper sheet elsewhere (dates on the left "Board Meeting Dates")…
-
Help with COUNTIF
Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…
-
How to use multiple IF and AND functions for symbol formula
Hello Everyone, I have a basic project sheet with Start Date, End Date, % Complete Columns. I would like a formula for Symbols to do the following: Gray = If todays date is less than Start Date Red = If todays date is greater than due date AND % Complete is less than 100 Yellow = If todays date is less than due date AND %…
-
Date Tracking
I need to track dates based on the milestone change. But i'd like to keep this in a separate sheet, but also include other key columns in order to create report. Example: Sheet 1 contains all data, Customer, ID, Milestones (drop down menu: received, submitted, etc.) Sheet 2 - need Customer, ID, and date that the milestone…
-
Formula Assistance
I am trying to identify how many times over the year a report was either received on time, late, or not at all. The reports are due to be received by the end of each month. The first attachment is the sheet which is being referenced. The report name being listed down the left side, and then identifying the date each month…