-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
Locking certain columns for parent row only
Hi, Is there a way we can lock certain rows of the parent row column so that no one can edit it? However, the child rows would not be affected by it. Thank you for your help!
-
Automated reports with attachments included
I have a few automated reports that go out every Monday. Is there a way to have this report (PDF or Excel) include the documents that are attached?
-
Inventory Management with Dynamic feature for Reagent Depletion from Assays Performed
I currently work in a lab that is looking to up their game on inventory management. We have an inventory smartsheet that gets updated after technicians manually check inventory in lab and update the sheet. Naturally, reagents get missed and our smartsheet becomes inaccurate very quickly. I'm trying to figure out a way to…
-
Automated actions are inconsistently triggered
When I enter a new Task into this sheet, I'd like to automate it so that all the other columns auto-fill. I'll set the automations to auto-fill default values, and then I'll simply change those cells that need adjusting. Setting this up felt straightforward, but now that I've got it set up it's happening inconsistently.…
-
Change a Cell Automation on Dates
I am trying to run an automation that will change the priority cell based on the date in a date column. See attached example. I want the Priority Column to automatically change to 1. High if the Due to Copyedit Date is in the next 30 days (or past) and the Complete box is unchecked. I want it to change to 2. Medium if it…
-
Autopopulating formulas for column
Hi, Is there anyway we can have a parent row column and have the formula "=IF(COUNT(CHILDREN(FindingType@row)) > 0, 1)" auto-populate instead of having to type each formula for every row of that column? I would like the formula to actually show as 1 for the parent row instead of '=IF(COUNT(CHILDREN(FindingType@row)) > 0,…
-
Dropdown options for approval workflows
For the approval automations/workflows that send out emails to specific personel with the option to approve or decline a request, it would be super helpful if SS would allow users to provide a dropdown list of standard rejection reasons. I work on a team that when a new request comes to Finance we have a list of 5 reasons…
-
User doesn't receive workflow notifications
I´m trying to figure out why one user can't receive email notifications from smartsheet. Context: I have a smarthseet to track QA Auduts and this specific workflow is to send the audited agents an update requesting to sign off their results. Due the nature of data in the sheet, Agents don't have access, so once the QA…
-
Auto populate a contact cell but still with overwrite capabilities
Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not correct. So I've got a Program column, a Suggested column, and a Assignee column. Program is a dropdown and Suggested…
