Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas9,161
- Project Management4,109
- Sheets3,373
- Reports2,346
- 形式2,079
- functionality1,966
- IT & Operations1,693
- Support1,424
- Cell linking1,384
- Enhancement Request1,374
- Automations1,362
- Email Notifications1,358
- Account and User Management1,353
- Integrations1,158
- Construction1,064
- Technology1,043
- Conditional Formatting1,034
- Dashboards931
- Manufacturing852
- Sharing and Collaboration810
- API and Developers746
- Calendar View716
- Product Development710
- Gantt View708
- Update Requests696
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=IF([ShipC Updated]@row = 1, 1)<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Have a fantastic week & Happy Holidays!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
You're more than welcome!<\/p>
You were off with the space at the beginning and the parenthesis at the end.<\/p>
=IF_<\/strong>([ShipC Updated]@row = 1)<\/strong>, 1<\/p>
if you wanted year and month combined, you could do that with the and function.<\/p>
Would look something like this:<\/p>
=[Percentage Column Name]@row * 8<\/p>
So if the percentage was 75, the result would be 6.<\/p>
Just replace the text \"Percentage Column Name\" to the name of your own percentage column.<\/p>