-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Project/Sheet Name in subject of Alerts/Request/Reminder
Hi everyone, I have a team managing several projects (80+) at a time. I have setup alerts, reminders etc for each project. So the same people will get alerts for different projects. How do I incorporate the project name (which is the sheet name) in the subject of those alerts so it is easy for the team member to know for…
-
Is it possible to have Form fields dependent on one another?
It would be extremely helpful for me if form fields could be dependent on one another. For example, if there was a field called Geography (with Americas, Europe, Asia Pacific as the three options) a secondary field called Market would populate dependent on the selection in the Geography field. I.e. if Europe is selected,…
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Dynamically Customize Alert and Request Messages with Placeholders
Type double-curly brackets around the column name {{column name}} in the subject or body, along with any other desired text, when typing a custom alert message—either at the time of creating an alert rule or while editing an existing one. For more information on this feature, see our help article:…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
How to get an approval after a decline in the automated approval request workflow?
Hi All, I have created an automated workflow based on a form submission that asks for the Approval of at least 3 individuals/roles. If an Approver declines, it will send and update request to the originator (Project Manager) and ask them to update information in the form. Once the Project Manager has updated the form, the…
-
Workflow becomes invalid after each trigger.
Hi, I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in form, approval request should get triggered. Since we are not sure, what column user is going to change, we kept the…
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Have a different email UI than what's in the request an update form
Hello - I am sending out pretty lengthly update request logic emails. I was wondering if there was a way that when the person receives an email they see only a few columns, but when they click the link to update the form, all of the columns appear. For example - I'm sending out an update request with about 24 columns. So…
