FORMULA
If we already completed the row task and it's marked complete, it will automatically change "Balance to Bill row" to 0. If not completed I want the cell to have the formula of Project amount minus QTY Billed so they can get the pending balance. Keeps coming up Unparseable.
See attachment. Thank you.
Answers
-
I've transcribed your formula and noticed a many problems
=countif([Project Status]@row, [Project Status]160), =[Contract Price]@row, [Contract Price]160-[Billed Ammount]@row,[Billed ammount]160, (0)
You have the countif() as its own function [ =countif([Project Status]@row, [Project Status]160) which is a valid function] followed by an unnecessary comma that is enough to get you an #UNPARSABLE to begin with. then you have a second "=", which is opening a new formula in the middle of the formula, getting you a second #UNPARSABLE error. that "=" leads to a single value followed by another error producing comma, which then leads into a formula happening in a void [ [Contract Price]160-[Billed Ammount]@row ] that goes nowhere and is not used, followed by another comma, followed again by a floating value, and then another comma, and finally a 0 in brackets for some reason. So yeah, quite a host of problems.
As for what you're trying to do, I suspect there may be a disconnect here. Smartsheets, much like Excell and Google Drive, is unable to have a cell remotely inform another cell, but rather it can only have a cell be informed by another cell. So essentially, if you want to have [Balance to Bill row]@row be changed, you will need to have the formula to change it be in the [Balance to Bill row]@row cell.
You're looking for something like =if([Project Status]@row="Complete",0, [Contract Price]160-[Billed Amount]160) presuming that the 160 rows are where you store that information and not @row. Does that about sound like what you're looking for?
-
It is what I'm looking for but after changing format it is now saying Invalid argument.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!