If a user is able to create more than one form for a sheet, then the sheet should have the capability to generate auto numbers based on that form. The automations are built based on the forms. Current…
We have a process where a document can be rejected several times until it's approved. I created 3 checkbox columns to flag the incoming updated document needing review. Somehow, when I write the autom…
I have two forms (internal and external use) which are attached to the same sheet. The internal form will be used quarterly when we want to push documentation to our external partner. We have set up D…
I've set up dynamic view for a customer to track their incoming work. I also have a mandate dissemination tracker which is used to internally track items. I'd like to have the customer's dynamic view …
I am the owner of the SS environment at my workplace and created several workflows. When the notifications are sent to recipients via automation, my name appears in the notification email. ex: <my nam…
My workflows send out automated emails to various recipients. At the bottom of each email, there was a blurb that said "You are receiving this email because you are subscribed to a workflow "Alert nam…
I would like to use the IF function IF(RMReview@row=Approved or Rejected,) The formula is unparseable and I agree. I just don't know what to place in the formula to get a date. Appreciate the help!
I have a workday formula in place now which calculates an expected due date from the date of submission. I've checked the results and find that the calculations are off by 10 days. The expected date s…
A metrics sheet was designed for my group with the following formulas embedded in the cells. I understand all except the $10. The reference links to the status column of a tracking sheet along with th…
Hello, I have one tracker where all requests are received and actioned. I have two dynamic views set up so that all internal employees can view the progress at any time and the other is client specifi…