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.
Auto Indent When Using a WebForm
I have some formulas on the 1st row and everything underneath are indented in order for the formulas to work. However, when a new entry comes in via the webform. The new row does not indent automatically. Does anyone have any suggestions?
Thank you!
Comments
-
Hi, Amanda,
I have this need, as well; I don't think there's any way to accomplish it out-of-the-box though...maybe with some customization, perhaps.
I usually just set up notifications to alert me when a new row is added so I can hop in and indent the row soon after it's submitted. Perhaps someone else will have a better idea.
Matt
-
Hi Matt,
That's exactly what I have setup right now so I can manually maintain it until we have an automatic solution.
Thanks for your feedback!
Amanda
-
You are all right, no way found to achieve this automatically, so it has to be part of the Check/review process when new data arrives and is processed for action, it is indented and possibly dragged to the correct Parent Hierarchy section for action.
Regards
RichardR
-
There are several other options in my toolbox:
1. The API will you to indent/outdent rows.
2. I have used Zapier to effectively move rows within a sheet. This is not a standard Zapier action, but it can be done.
3. If your only reason to indent is to use formulas with CHILDREN() or PARENT(), then careful redesign of the sheet may remove this liability. I don't encourage this, as I like to collapse/expand rows as my visual needs change during the work-day, but it is an option.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives