-
Where can I find column ID in smartsheet?
For row, this is very easy. But it's not clear for column. Where Сolumn ID?
-
Why won't my dashboard update automatically?
I have a dashboard that references one sheet. The dashboard will not update unless I make a change on the sheet it references. I've tried refreshing the dashboard several times, checked on my phone smartsheet app, different computers, its not updating anywhere. Once I make even a minor change on the sheet it references and…
-
Cell Linking to Wrong Sheet When Provisioned
In our blueprint in Control Center, we have added a new sheet that has several cells linking in from another existing sheet. In other sheets/projects, the cell links update so it links to the new project sheet when the project is provisioned. However in the sheet we just added to the blueprint, the sheet is created just…
-
Conditional Formatting
Hi! I am using conditional formatting to generate different colors in cells based on project status. Green is project is complete Blank is project is in progress Yellow is project is in progress, but it is overdue by 1 week or less Red is not complete and overdue by 1 week I have different steps and each step has an…
-
Tracking Progress changes in a column leveraging workflow
Hi All, I wanted to get someone's feedback on what you would do with the following predicament. I have lots of activities (rows) associated to a columns, e.g. Program 1, 2, 3, and 4 which contains dropdown 'In-Process' and 'Pass' Statuses. What I need is when a user selects the a new status e.g. In-Process that Smartsheet…
-
Smartsheet Forms - Vlookup to auto-populate choice on form
Hi There- Wondering if this form functionality exists... When someone selects "SEM Vendor" from the dropdown, I would like the "Ship to Location" field to auto-fill by a v-look up on a different sheet.... But if the vendor does not want the default location I would like them to be able to overwrite it on the form. Thanks-…
-
Update/Change a Template
Is there a way to edit/update a template without using the template to create a sheet, editing the sheet, and saving as a new template? This process creates additional templates that might have to be renamed and then removed. I'm looking for something that makes the process a little easier. Thanks! Regina
-
Linked Cells Not Updating
Within the same workspace I cells linked between sheets, just a simple integer that changes week on week depending on the new core data added. This workspace has been working great for about 2 months and all of a sudden a hand full of these linked cells don't update. E.g. Sheet 1 has a cell of value 175 and that is linked…
-
How can I see who responded to my approval request, as in who hit the "Approve" or "Decline" button?
We use Smartsheet at my company to track customer approvals, however the way we have it setup, the approval request gets sent to a Customer Service Representative who then forwards it to the Customer. We want to make sure the Customer is the one who is approving or declining the request and not the Customer Service…
-
Filter report to only items where comments mention specific text
I'm looking to create a report that will show me only the records where I am mentioned/tagged in the comments. This is not a comments column, we are using the standard 'comments' functionality. Would even be sufficient to just filter on any rows where the comments are like '%SomeText%'. Seems fairly similar to this post…
