-
Vlookup cell isn't multiplying with another cell.
Hi guys whenever I am trying to multiply my Vlookup cell with another cell it gives a Value error. I have linked web data to other sheets and have a vlookup for specific data in cell D6. In G6 I then want to multiply D6 by a value in F6 using =D6*F6, but a value error occurs. I have also tried copying and pasting the…
-
Can I sent an Alert in a sheet (column) to a Smartsheet Group?
We have a sheet that a "group" works, I want to send an automated email to the "group" that a line has been added. I have created the "group" in Group Management. What would be the best column type/ column properties to use to make this happen?
-
Automated Workflow - Alert Notifications
Happy Friday SMEs! Is there a way to confirm an automated workflow "Alert" actioned properly. For example, when generating an "Update Request", you can validate if/when the request is completed by referencing the toolbar highlighted below --- Is there a similar feature (or mechanism) to track when/if "Alert" workflows are…
-
How to block a cell on formula
Hi, I want to know how can I lock a cell in a spatial working formula. Example: = IF (AND ({PROJECT CASE TEST Rank 7} = January1, {PROJECT CASE TEST Rank 6} = January2), {PROJECT CASE TEST Rank 8} + {PROJECT CASE TEST Rank 9} * January5, "") When I pull the formula left, right or down, the cell formula can't blocked and…
-
Automatic Workflow Email Trigger for Dependency Rows
Do we have the option to send an email alert to the next person in the activity once the prior activity is marked as completed? I tried to do this using the "Request for Update, but this doesn't work. Could you please help?
-
I used automation and move a row and the row disappeared off of my sheet but did not appear on the t
I do not see an error log, additional columns headers were added to the the target sheet but no data ever appeared. how can i find out if there was an error or even see my data? I changed it to a copy so I would not "lose" any more data until I got it figured out.
-
90 Day follow-up alert
Hello All, I am trying to create an automation that notifies me 90 days after the Actual Closed Date so I can do a follow-up. Is there a way to do this or do I need to do a workaround formula that calculates 90 days after the date in that field and then have the alert be once that date is reached to send me something?
-
Sheet Owner on Automation Emails
When a notification is sent, the automation email is sent like it is coming from the Sheet Owner rather than the user that actually updated the row and triggered the notification. This is confusing because often times our customers don't know who the sheet owner is or they don't interact with that person. Can this be…
-
automation with clock timer
Hello , Date column is not enough for automation updates/approvals and reminders , we need to send it conditioned on time formula ( clock ) . For example like to insert task time and and to create automated reminder / update or approval request that with condition based on time , like if the time is 1,2, 3 hours is less…
-
Workflow automation to alert people upon cell change from 'unchecked' to 'checked'
Hi, An automation workflow is created. Specific people are assigned to be alerted upon cell change for specific row from 'unchecked' to 'checked'. Workflow to run when triggered. After trying multiple times, the workflow seems not to be active and working. See image below. Please advice, thank you.