-
Dec 10 Release Notes
There are no release notes (yet) for yesterday's release. https://www.smartsheet.com/release-notes I was hoping to test new and existing functionality today. Also: November's release isn't listed here: https://www.smartsheet.com/product-roadmap Craig
-
When I import a previously exported timeline, the Gantt looks very different. How to fix?
Every horizontal line in the Gantt is blue... there are not dependency arrows, no milestones, etc... How do I fix this? I should be able to export and re-import my timelines without losing information/functionality. It's almost as if this limitation has been imposed to force people to upgrade, since I only get 10 timelines…
-
Sorting in Reports
I have several reports where the report is sorted in decending order based on one column's values. None of my reports are sorting properly this morning. This has never been a problem in the past. How can I correct this?
-
Using RAGB plus adding Blank Cell action
I am trying to use the RAGB indicators to look at if a Due date is set and then setting the Indicator to Red if in the past, Yellow if in the next 3 days and Green if in the future beyond 3 days. We are also using the Blue to indicate if the task is complete. This works fine with the following formula, however for blank…
-
Conditional formatting based on Cell History
Hi Is there a way to format a row - based on when a partcular Cell was modified rather then when anything in the row was modified? In this example I would like to format the row based on how may days the Client has been at a particular status Thanks Lee
-
Help Using "IF" condition
Hi There, I need your help regarding "IF" condition. I want to create an "IF" condition to do the following job: " IF column 1 is checked, then show today date in column 2" Thanks in advance,
-
Freeze date
Is there a way to freeze a date =today() if a date field is controlled by a check box field once 24 hours passes? If check box checked = today. Excel suggests using vba. I am not certain if there is a way in SS to do this type of function without the date changing. Thoughts...suggestions?
-
Form Summary Email
Hello We have a sheet set up (for Travel requests across our business). We've set up a form for users to fill in with all the basic request details, which then populates the sheet. The admin team are then able to log into smart sheet and complete the rest of the row fields with booking details, costs etc. We've got an…
-
Conditional Statements
Hi Everyone, I would like to as add formula to the start date and finish date of the task/project like, if the duration is less than 3days, the result will "rush fee applies" like a note. And, another formula is for language services or any other; language checks box yes or no if I click on yes those languages will appear…
-
Multi Project Milestone Report
I have a series of projects that I need to report out the End Date for each of the milestones and I'd like to do that in a table. So here is what I have. I have 7 projects, each with 7 Milestones, each with 1 dates. I laid those out in a report as 3 separate columns - Project, Milestone, Date. So what I need a table with…
