-
Inconsistent Date Options
Hi I recently came across 2 date-related options which look inconsistent within the app. Would be grateful if the smartsheet development team can address it soonest! The Inconsistency: In the Workflow-Automation we can set a Condition as <any date field> is not today; whereas in the Conditional Formatting dialog, we don't…
-
Auto-Lock All the Child Rows
Hi All I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanism. Thanks in advance! Nasir
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
If Formula
Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondence, Days till follow-up, Next Follow up Date is the column that I want to auto…
-
Automation from a form submission
Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…
-
Automation - Request Update
Hi. I'm looking for help troubleshooting an issue I"m having with Automation in smartsheet. I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet. The problem I'm having is my request automatically includes a form I created for project intake. I do not want the…
-
Update Requests
We have an automated update request created, however, when it is triggered it sends a link to update all fields that need updating to all contacts within the sheet - as a result they are not using it as they cannot see which action is theirs to be updated What we would like to happen is that the update for that row only…
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
