-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
Smartsheet Employee Dashboard functioning like an app
Hi there I have created a Smartsheet Dashboard for each employee, with sheet visual icons related to their worksheets. It serves as a quick link and hosts only the sheets they need to access and work on. The Icons are categorised as per our company's production and accountability structures. It resulted in no further…
-
Automation Group Deactivation
It would be great to be able to click a block of automations that can deactivate and reactivate automations as needed especially when fine tuning or making improvements on a sheet so that a notification does not go out in error. This would also help when you "save as new" a sheet for another project where you want to keep…
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
Request an Update sending multiple lines in 1 email
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
-
mailto: Function in Sheet Cells
Imagine the following situation: you’re working within a worksheet and want to add a hyperlink to a cell, you can reference a URL or another Smartsheet file. But I’d like to reference to an e-mail address. E.g. we got our suppliers names in this cell, and want to write them as fast as possible a message. And by just…
-
Seeking automation for Monthly Dashboard with separate Month Rows
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
-
El campo % de avance lo edito pero se cambia en automatico a otros valores
Buena tarde necesito apoyo. En mi columna de avance porcentual solo puedo manejar 0%, 70% y 100% cuando pongo cualquier otro valor en automatico me lo cambia a 70%, este sheet no lo cree yo, y ya busque en sus configuraciones y nada. Ojala me puedan ayudar, ¡Saludos!
-
Logic for parent row status
I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: If…
-
Automatic emails for approval - intermittently not sending
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…