Best Of
Re: Webhook delay with attachments (1-2hours!)
Hey @Craig Watkinson
No problem! I would send them the following:
- URL of an example sheet you've seen this happen on
- If it happens on multiple sheets, identify this
- If it happens on a copy of the same sheet, identify this
- Timestamp of when the attachment was added
- How the attachment was added (e.g. Form, Update Request, Manual, API)
- Screen capture of the Activity Log with the attachment added shown
- Timestamp of when the Webhook notification received for that attachment
- Screen captures if possible
This should help point them in the right direction! They may ask for more information but it's a good start.
Cheers,
Genevieve
Genevieve P.
Re: Link % completion and Status fields
I made mine work with this statement
=IF(AND([% Complete]1 > 0, [% Complete]1 < 1), "In Progress", IF([% Complete]1 = 1, "Complete", "Not Started"))
JasonRiley80
Re: Activacion de TRIAL Resource Mangement
Gracias por responder mi consulta.
Entonces comprare una licencia temporal por un mes, hasta que mi gerencia me apruebe presupuesto.
Saludos, nuevamente muchas gracias.
Giovanni Angeles
Re: COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
Try this instead:
=COUNTIFS([Pending]:[Pending], @cell = 1) + "/" + COUNTIFS([Pending]:[Pending], OR(@cell = 1, @cell <> 1))
Paul Newcome
Re: Getting Invalid Operation using Countifs with two fields
UPDATE: I figured it out. I am embarrassed to say it did not occur to me initially to change the 100 to a 1 instead (because without the percentage, that is the full value). Thanks for the help!
I have been trying to manipulate the formula based on your info above but am still having issues. Here is where I left it - it does give me a number (rather than an error) but I have two test rows set up to meet this criteria, yet the formula returns zero as the count
=COUNTIFS(Status:Status, "Tech Assist", [Overall Percent Complete]:[Overall Percent Complete], 100)
It is definitely the overall percent complete part that is tripping it up - if I do just the first part with a COUNTIF it works just fine - I have tried with an equals instead of a comma, with and without a percentage sign, and with and without quotes, all throwing some kind of error. Any other thoughts?
DKManley
Re: Help with a checkbox triggering a formula
Hey man,
Try this formula:
=IF([ITEM 1]@row = 1, IF(NOT(ISBLANK([ITEM 1 QTY]@row)), [ITEM 1 QTY]@row * 10.4))
This will work only if the check box is checked and there is a quantity in the "Item 1 Qty" cell.
Let me know if it works!
Thanks,
JRR
JR90
Re: Formula to flag required approvals and if they've been obtained
Thank you both, I've learned so much from this thread and your comments on other threads as I was troubleshooting my issues this week.
Lauren Lederle
Re: HOW-DO-I: Send All Row Attachments when PDF is generated?
Hi @NeilKY
I'd like to extend your use case with the solution described below:
1. Create 2 new sheets :
- Suppervisor sheet : create an Alert workflow (based on a new row added) to notify the Supervisor, including attachments (Alert 1).
- Approved sheet : create an Alert workflow (based on a new row added) to notify you, including attachments (Alert 2).
2. Destination sheet : create 2 new Copy-row workflows
- After the request is approved > Copy row to Supervisor sheet > Alert 1 will run and notify the Supervisor, including the image.png.
- After the Order.pdf file is attached > Copy row to Approved sheet > Alert 2 will run and notify you, including the image.png and Order.pdf.
Hope this works for you.
Gia Thinh
Re: HOW-DO-I: Send All Row Attachments when PDF is generated?
Yes, you're correct. The alert workflows will include the attachments that are added to the row at the time the workflows run.
Gia Thinh