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.
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter once completed. My main issue is that if I use the column select function [EX: =avg(row:row) ] to select the whole column I can't have it change when new rows are added. ex of what I need =avg(row1:row) so the new information added doesn't effect the old columns. In excel I would just use 1,048,576 as the maximum, but in smartsheet the maximum is fluid. Any help would be appreciated.
This is the formula I wish would work in my system (input on first line)
=IF(Plant1 = "DM", ROUND((COUNTIF(Plant1:Plant, "DM") / 9) - 0.5000001, 0), IF(Plant1 = "DF", ROUND((COUNTIF(Plant1:Plant, "DF") / 6) - 0.5000001, 0), IF(Plant1 = "VF", ROUND((COUNTIF(Plant1:Plant, "VF") / 6) - 0.5000001, 0), IF(Plant1 = "CORP", ROUND((COUNTIF(Plant1:Plant, "CORP") / 4) - 0.5000001, 0)))))
Comments
-
Hi Luke,
Don't use row numbers when referencing an entire column. Example: =IF(Plant1="DM", ROUND(COUNTIF(Plant:Plant,"DM")/9)...etc...etc...
Take the 1 out of your Plant reference when referencing the entire column.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives