-
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect status…
-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Formula using both an IF and SUM(CHILDREN()) parts
Hello people I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty. If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5) I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5)…
-
Conditional Formatting at Sheet Level - not row/column specific
Hi there knowers of knowledge, Is there a way to set conditional formatting so that across the sheet if the condition is met the format is applied. Think: if sheet contains 'YES' apply this format, across the entire sheet. Thanks!
-
Conditional Formatting Changed Over This Weekend
I've got a development backlog I keep in Smartsheet. Many of my checkbox columns have conditional formatting - red when not checked - normal when checked. I have header rows that I inserted a period "." into and changed the font color to match the row to hid the conditional formatting. Now, the conditional formatting is…
-
Misc feature requests
The following features/enhancements would be useful: * -Card view also for reports * - Conditional formatting applied in reports * - BOX task integration (tasks assigned in BOX could be displayed as a separate report) * - Reports from reports, not only from sheets. This would enable more advanced filtering * - A report…
-
Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
-
Showing weekend dates with conditional formatting
Hi there, Is there any way of showing weekend dates with conditional formatting? I would just like to add this to my schedules, so that when they're being updated, any dates that knock on to a weekend are highlighted for me. Note: some of my suppliers work at weekends and some don't, so I can't just change my settings to…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
The Time it Took to Perform a Particular Action
Hi, I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action. I,e. let's say there's a task that somebody is assigned to and they begin this task by…
