- Auto-populating a range of columns with a number based on dates in 2 other columns.
Hi, I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 USD. I would like to populate columns Jan 2022 through October 2022 with 1,000 USD in…
- Additional Options in Row Copy Automation
Please add an option to add row to top. "The row will be placed at the bottom of the destination sheet and can then be manually dragged up or down to a different location."
- 我不能复制/粘贴文本的奥特曼ation. Anyone else?
I've discovered an infuriating bug (?) or complication with dealing with automations in smartsheets. I have a variety of automations in a key sheet that have email alerts for certain contacts. in these emails I have a link, specifically to a dynamic view but that is irrelevant, that I am trying to copy out of the body of…
- Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
- Request Approval Automation working in one direction only
Hi Guys I have an automation running for approvals. Ill add an image for reference. What I'm trying to achieve: We want PERSON A to be able to make a request to PERSON B. B must then approve or decline. Upon B's approval a new Approval Automation is triggered back to A to accept what was issued. We have about 50+ PERSON…
- How to set the automation to trigger when status column in all rows are "Closed"
I am using Smartsheet for inventory stock count, and want to trigger an approval when staus column in all rows are "Closed", and then the approver could approve the whole sheet in just one step. Is there a way to do this?
- How to include a customer satisfaction feedback after a form is submitted?
We have developed a form recently for our Business scenario and we would like to add in a feature. I am not sure if it is existing as of now in Smartsheets. We need to send the user who submitted the form to fill an Satisfaction from scale of 1-5 along with smiles. May I know how can this be done?
- Cell linking based on the cell value from the source sheet
Let's assume for a second that I have a file that is titled "Project Info". I also have a folder called "Projects". Every file in the project folder has the same columns though the project names are different. In Project Info, each filled row will have a unique key that references one of the files in Projects. What I am…
- Changing labels on approval workflow
Hi, I am creating approval workflows and was wondering if I can change the labels on it. The default are 'approved' or 'declined'. Is there a way to change that? For example, I'd like it to say 'approved' or 'feedback provided' instead of declined. Thanks, Natasha
- Form - Copy of Answers
Hello, Is it possible for a form submitter to receive not just their answers, but also a copy of what they filled out? Our form has information in the question descriptions (not just the Q&A fields) that we'd like them to have a copy of. If they can't receive the whole form along with their answers, is it possible to add…
