Only 1/2 of my formula is working
I am currently creating a Smartsheet to track payment issues. When a date has been inputted along with a status the future date generates to an additional column to display how long it will take for the payment issue to be resolved. However, only half of my formula is working and I cannot any problems in the formula which I have copy and pasted below. Can anyone advise?
Thank you so much😊
=IF(OR([AP Payment Status]@row = "Invalid Approver", [AP Payment Status]@row = "Reprocessed", [AP Payment Status]@row = "Invalid Coding"), [Date Flagged to AP]@row + 2, AND(OR([AP Payment Status]@row = "Payment Rejected", [AP Payment Status]@row = "Awaiting Approval"), [Date Flagged to AP]@row + 3, AND(OR([AP Payment Status]@row = "Payment Returned", [Date Flagged to AP]@row + 5))))
Answers
-
What is your criteria? How do you expect the formula to work exactly?
-
Hi Paul,
So when someone adds a date to the "Date Flagged to AP" column, and the status is updated, depending on the status a date will generate (ex: 3 days) to solve the issue, that will populate in the Date of Resolution (hopefully that makes sense)
-
I understand that's the general idea, but what is the exact logic? There are a number of syntax issues with the formula you posted, so I wasn't able to figure out exactly what you were expecting it to do. Are you able to list out each status and how many days would be added to each?
-
Sure no problem
Invalid Coding- 2 days
Reprocessed- 2 days
Invalid Approver- 2 days
Payment Rejected- 3 days
Awaiting Approval- 3 days
Payment Rejected- 5 days
-
Ok. Give this a try...
=[Date Flagged to AP]@row + IF(OR([AP Payment Status]@row = "Invalid Approver", [AP Payment Status]@row = "Reprocessed", [AP Payment Status]@row = "Invalid Coding"), 2, IF(OR([AP Payment Status]@row = "Payment Rejected", [AP Payment Status]@row = "Awaiting Approval"), 3, IF([AP Payment Status]@row = "Payment Returned", 5, 0)))
-
it worked!! thank you so much!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!