How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All
I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me.
Did any of you faced a similar problem? What would be the solution?
Thank you
Comments
-
Hi Noemi,
Depending on your use case you could have the formula point to the whole column. Then you don't have to worry about it.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
I tried what you have suggested, my issue is that if I put 5000 in the formula then my formula doesn't work as the rows do not exist yet/ they are created as the entries are coming in. If I create blank rows up until 5000 then they cannot use the web form as the sheet is full and there is no room for new entries. Any suggestion how this can be solved please?
Thank you!
-
Hi again Noemi,
Have you tried columnname:columnname? This takes the whole column in the formula and you don't need to worry about the number.
Example:
=COUNTIF(Package:Package, [First Name]4)
https://www.smartsheet.com/blog/support-tip-range-formulas
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This works!! Thank you Cheers!
-
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!