-
Comment Automations
Greetings, Smartsheet Jedis! Is there a way of setting up an automation that alerts "specific people" as well as a "contact in a cell" whenever a comment is made on a sheet WITHOUT sending an alert to the person that submitted the comment? We currently have an automation in play that pings everyone whenever a comment is…
-
Comments Not Updating Immediately = Automations to Fail
Hello - why are my comments being posted 5 minutes behind..........causing the updated comment automation to fail? My comments show being posted 5 minutes behind causing my comment automation to fail?
-
Pulling Status from another Smartsheet
Hi, what is the best method to pull the status update from a different Smartsheet? Our technical team has a Smartsheet of tasks and I'd like those tasks and the status be reflected on the overall project plan. However, I only want them to be required to update one Smartsheet. Recommendations greatly appreciated!
-
Expired Assets - Workflow
Use Case We have assets where the usage has expired, and in BF they are marked as expired. My team though (guest users) need to see these assets at any time. They will review and determine is we should license again. How do agencies go about enabling this? This is a really important need for us. Also is there an automation…
-
Require a number format
Is there a way to force input in a form to be in a specific number format? For example, require that a customer number be 10 digits, or an account number be XXXXXX-XXX?
-
Finding the most recent entry
I am having issues finding the most recent update to my list of fleets. I have read about the Max(Collect()) function and don't quite get the result back that is needed. I get incorrect column value, incorrect funciton, etc. or when I have been able to get it to run I get back a 0 instead of an actual date. I have tried…
-
Need help with nested IF equation
I have an IF equation that is working fine for me, however, I would like for anything that is past due to be "Red" in the task health bar. Right now, because I have "Grey" as the first clause even if an item is beyond it's end date, if it is "0%" complete it shows as "Grey." How do I adjust the formula to make any thing…
-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
-
Implement 'partial match' search on drop-down lists in Dynamic View so it works in same way as sheet
in a sheet - a drop-down list column with allow multiple values selected offers a 'partial match' text search capability so that typing words in the middle of a text string will result in a shortlist of options being shown. This is excellent. However - the same column when used in Dynamic View only provides an 'exact…
-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…