Hi, I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned to so I know when the project should be done. Building a house may require someone to build…
I'm creating a calendar with all the different tasks our leaders need to do each year. Is there a way for me to color coordinate so each task is the same color every month without going one by one? The screenshot below shows how you can do it for one item but that's too tedious. I've tried conditional formatting but that…
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
I'd like to create a conditioning formatting to highlight a cell based on the difference between two dates. Column A is the expected date of delivery. Let's say 1/1/23. Column B is the actual date I received it, say 1/5/23. I'd like it to follow this rule: Highlight Column A cell when: Received date is more than 5 days…
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
Hi, I have a training spreadsheet for my staff, that has two columns, one for a required level and one for the completed level. I want it so that if the completed and required columns don't match in a particular cell, the either of the completed or required cell highlight to another colour. This will make is easier to spot…
I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…
This discussion has been merged.
Colum A Date - has a date ( if in the future ) Colum B - should show me the countdown as per the current date
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
