Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Is there a formula for averaging the remaining?

Comments

Mike Wilday ✭✭✭✭✭✭

10/16/17 edited 10/16/17

Thanks, Craig for helping out there! Angie, glad it got sorted out and working for you.

0 · Share on Facebook Share on Twitter
J. Craig Williams ✭✭✭✭✭✭

10/16/17

I hope I did not step on your toes. It looked like you and Angie were talking around the problem without agreement.

Craig

0 · Share on Facebook Share on Twitter
Mike Wilday ✭✭✭✭✭✭

10/16/17

Not at all! Just glad we were able to help out!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.
Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…