-
Update request file visibility
Is it possible to send an update request and allow the recipient to see sheet attached files (i.e., not attached to the specific row)? The reason I'm asking is we are trying to use the sheet for Bid Management and I have it all sorted out except when I send s bid request (update request) out to a trade I want them to have…
-
same rows in different sheets - can i make changes to a cell in one sheet and it gets updtd in other
I am not sure if this is possible within Smartsheet, but still keeping my question across I have a master sheet with a workflow. here a row is copied (not moved) to another sheet if it has the Name of the Responsible person. I am using this sheet for tasks. This workflow is running all fine. Now what i want is that when…
-
Get click / view data from a dashboard
Hello everyone, Does someone know if it is possible in Smartsheet to get : The number of views of a dashboard related to the person who visit the dashobard ? Data about which part of the dashboard the person have achieved ? (example: if there is 4 items to click in the dashboard, has the user clicked on the 4 items or…
-
Coping with Change & Uncertainty -Videos by Joseph Michelli for the Smartsheet community
Some inspiration for the Smartsheet community during this time from Joseph Michelli, a Smartsheet Alliance One member, past ENGAGE speaker, as well as best-selling author and psychologist. He thought the Smartsheet family could be helped by messages on how to cope during this COVID-19 situation. Please find two videos…
-
#CIRCULAR REFERENCE auto corrects after I copy and paste the exact same formula.
I have theories as to why this is occurring but, for now, here is what happened. One of the sheet formulas looks something like this: =IF([COLUMN A]1 = "YES", INDEX({Smartsheet 1 Column B}, MATCH([PROJECT#]1, {Smartsheet 1 Column A}, 0)), IF([COLUMN A]1 = "NO", INDEX({Smartsheet 2 Column B}, MATCH([PROJECT#]1, {Smartsheet…
-
Predecessors - Auto populate dependencies
I am looking for a way to Auto populate/adjust Dependency length on my predecessors. To further explain: I have my projects setup with multiple Widgets. Each widget starts based off a lag time from the start of the widget before it. IE: This is representing that mod 1 and 2 start on the same day, and mod 3 and 4 start on…
-
Moved: Request Tracker Form
This discussion has been moved.
-
Marking task "Complete" with a checkbox?
Hey everybody, This should hopefully be pretty straight forward but I'm having trouble figuring this out. I'm trying to build out dashboards for my team that they can easily go in and check a box to mark a task complete. I've added a checkbox column into my sheet but now I need to figure out how to link that to my "Status"…
-
multiple approval flow
Hello, I would need to set an approval flow with consecutive approvers (when Approver 1 approves, flows goes to Approver 2, and so on up to 11 Approvals), which I managed to set up. However I have scenarios when 1 approval level needs to be spiked (approver is also not filled in for those cases) and the flow would need to…
-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…