-
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,…
-
Copying from sheet to another sheet but not all the information from one row to another one.
Is it possible in Smartsheet for a new row appearing in one sheet to trigger the creation of a new row in another sheet, copying some—but not necessarily all—of the information from the row in the first sheet to the new row in the second?
-
New: Sheet limits and performance improvements
Anyone any idea when the new sheet limits and performance improvements come in? I just received the early visibility of this happening. Great news and looking forward to it. New sheet limits: 20,000 rows 400 columns 500,000 cells 100,000 cross-sheet referred cells Improved performance: 2x improvement on sheet load time 6x…
-
Need to Strategize with Advance SmartSheet User
I work for a law enforcement agency. I need to create a grid that lists available officers that can be pulled from other units to assist patrol. Each unit will have a specific number of officers available. But when one officer is pulled and then returned, I need to make sure that availability is shown without losing the…