-
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,…
-
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…
-
Trigger automation based on a count or multiples of a count
Hello. Im testing out triggering an automation based on a countif, but I cant figure out the logic to apply the automation as the countif increases. For instance. I want the automation to run each time we get 5 submittals via a form for the same category. Right now I'm using a metric sheet and a countif with a mod…
-
Formula for quarter based on finish date
I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to be "Q2".