- 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
当发送通知,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.
- Moving Parent and Child rows to other Sheets
Hi, Looking for some help moving rows to another sheet. We use one specific sheet to track ALL deliveries that come into our warehouse. A clerk in the warehouse makes a Form Entry for every group of items on the same packing slip, and attaches a photo of the packing slip for reference. Remotely, another clerk will read the…
- Automated interactive Subject line and email / Update request
I love the the automated update/approval emails feature and i wonder if its possible the subject line can add more information with a code trigger from one of cells and not to have the exact same subject all time Also the sent to email to be triggered from contact email and not same email setup Thank you
- Notification delay
I have a series of workflows set up for a form/sheet I am using. The process goes like this: 1. Someone submits form 2. Triggers approval email to be sent 3. If approved, this triggers an email to the requestor that their request has been approved. 4. This also triggers a different email notification to another email…
