-
Automation is not looking at my Conditions - Checkbox
Hello, I am having an issue with my automations. This sheet is pretty simple, a date column is my trigger and it will shoot off the notification unless a checkbox is checked. The issue is, automations keep coming through despite the checkbox being checked in the sheet, however the email it sends shows the checkbox as…
-
Highlight a cell that has not been changed in X days
I want to highlight a cell named "this week's progress" if it has not been edited in the past 8 days so the viewing audience will know it has potentially "stale" information in it. Ideally the cell would tint yellow after 8 days and red after 16 days. I just do not see a way to do this using conditional formatting or…
-
Summary Sheet History
I have a summary sheet for my smartsheets. It contains several fields, including 3 fields that are updated weekly manually. I'd like to create an automated way to save the values of these manual fields ( Date, text, text ) so I can refer to them for historical purposes and evaluations. I can't find any way to do this. Any…
-
Auto number when box is checked
question on how to generate a number when a checkbox is checked. This seems simpler than other peoples asks, but I can't seem to make it work for me. screenshot is the area that needs to be addressed. I want the [PO #] (currently set to auto-number every row)to generate the next number ONLY when the [PO needed?] is…
-
Referencing Another Sheet - VLOOKUP vs INDEX vs ??
Hello, I need to populate a cell with a number that is in another sheet based on an independent UID found in a different column that will be on both sheets. Not sure which direction to go on this -- For each line form-generated line, D. needs to look at C., find/match the data to A., then populate D with B when: A.…
-
How can I trigger an IF statement only once?
I have a column that is a single select drop down menu. We use this to keep track of who is responsible for that line as the project moves through our departments. A couple of the selections are outside our company. We want to record in a separate column who the outside contractor is. I am attempting to copy the name of…
-
Workflow automation
we have workflows set up that are working beautifully. Until recently. There is now a duplicate workflow under my name/account and I can't figure out where it is pulling information from or where it is set up! Does anyone know how to identify where a workflow is pulling from?
-
Workflow Automation - Assign People Function.
I have created a Shift Rota for my team. The left axis displays the day and date, the top axis displays each person broken down by team. In the table each person on each day gets assigned a letter depending on the shift they are assigned to (e.g D = Day Shift, A = Afternoon Shift). I have then set up an automation to…
-
Modified Date(auto populated by system) get changed for all record without any modification in sheet
Hi Team, In my smartsheet, Modified date which is an auto populated/system generated column, gets changed automatically for ALL the records even though we are not doing any changes in any of the records. This is causing issue in our workflow. We have defined modified date as the trigger point of our workflow. As a result,…
-
Checkbox workflow just stopped working...
All of a sudden, the below workflow is not working. I have tested and demoed this functionality many times and it has been working great—and then Tuesday morning it just wasn't working anymore. In the automation tab, it is showing the workflows as having been just run (see below) but the checkbox not actually being checked…