-
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…
-
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".
-
Why is my automation to copy rows to other sheet missing data from certain columns?
I have an automation created that, when a row is added to sheet 1, the row is copied to sheet 2. Its working fine except it sometimes misses values from the "First Pay Date" column and the "IC" column and they dont get copied over. They will just be blank on sheet 2. I made sure that under column properties, they are set…
