Date and Balance Formula
Hi there,
I need help creating 2 formulas
- I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately.
- The second formula would essentially be the same if the Week Ending is a specific date what are the number of hours being requested.
I appreciate all of the help
Tags:
Answers
-
I think you're looking for something like:
=IF([Week Ending]@row = DATE(2020, 1, 12), [Balance]@row, 0)
Let me know if that isn't what you were looking for.
-
Hi David,
I tried the formula to see if it's what I needed but it's coming up as #UNPARSEABLE not sure what I would be doing wrong.
-
Try taking the [] off of Balance and just have Balance@row to see if that changes anything.
-
Hi,
I guess I didn't explain myself correctly, what I need is a VLOOKUP formula that will look up the current week ending and provide the balance for that week ending so that I can cell link it to a master sheet. If that makes sense
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!