I have an intermediate sheet with only one row that pulls the results of some calculations from my master data sheet in order create an archive entry. This intermediate sheet has an automation set up …
I'd love to find Smartsheet consultants that could revamp, update how we currently use it to maximize, utilize the portal function, address automation's, alerts, set up some reporting etc. Not looking…
Hi, I have build a functional, if not exceptionally efficient, UAT process in which individual tests for a product feed up via cell links to a "Master Product Test Sheet". In this sheet the "Approver"…
Trying to correct my SUMIFS formula include two criteria from a multi-select column. I'm currently getting UNPARSABLE every time try OR, AND, or HAS. Here's what I have so far with my current criteria…
Hi, I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in…
Hi, I have setup a few automated rules to alert a user within a column (me) to changes to specific fields. I can't see what I could have done wrong in the config as its such a simple thing to setup bu…
I managed to create a workflow in a report but I am now unable to get to the existing one to edit it OR create a new one. There was a pop up that got me to the automation workflow page to create the f…
Will the automation “Request an update” fail if the 'Condition' column contains a cross-sheet formula that pulls data from another sheet? For example, there are two Smartsheets: Sheet ONE contains Pro…
I have a sheet with a list of employees that references form responses on a different sheet, and via vlookup function pulls in the date a form was submitted (to track who has submitted the form, and w…
Hi, I'm having an issue where an automation won't send an email. My personal settings are correct. It will send the email if I input an email address, but it will not dynamically pull that email from …
