-
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β¦
-
Convert into column formula w/o syntax error
Hello, Could you help me please ? I try to convert following formula into column formula w/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor
-
Approval Workflow not sending notification
HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and subsequent actions, but both flows end with a notification step. The "Above R5000" = Yes" condition works perfectly but the "Above R5000 = No"β¦
