-
Cancel reoccurring update requests when complete (or 100%)
Hi All, I might be missing something, but I want my reoccurring update requests to automatically stop sending when the activity they relate too reaches completion. Anybody know how to do this? Appreciate any guidance you can give me. Mike
-
Base rule off of 2 columns
I'm looking for a way to create a rule that would be: If Column "Status" says Funded, and Column "Fee" is blank, make the row Yellow Is there a way to do this? I can't seem to figure out how to get 2 columns on there to create the rule Thanks!
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Can hidden field on web form designate parent-child row status automatically?
Our Smartsheet has a client name column along with a designator column that indicates what type of work we are doing (M, S, or C). We have a web form set up for each (M, S, or C) using the hidden field so that when an "M" form is submitted, conditional formatting tells it to bold and back fill the row. Is it possible to…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Access (visibility and the option to edit) to SOME rows in a sheet
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of the departments however, requires visibility of their related tasks, therefore I have…
-
Calculate days since a bubble turned red
I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days since a bubble turned red. This would tell me how many days it has been since a project…
-
Highlight next date
I can't find a way to conditionally format a date field to highlight the closest dates only. For example, if sheet has: 08/30/2018 08/30/2018 09/04/2018 09/04/2018 09/13/2018 I want to automatically highlight the 8/30 dates. They will fall off the sheet after the 30th, so then the sheet should highlight 09/04 rows. Is…
