-
Process mapping
Does anyone use a process mapping tool such as Visio or TaskMap that can integrate well with Smartsheet?
-
Conditional Notifications
I would like to be able to set up a conditional notification that allows the next "assigned to" person to automatically receive a notification when the task before theirs is completed or checked. There are about 5-7 different people that would need to receive this type of notification. Does anyone know how I can easily set…
-
Printing errors
When printing a sheet with a Gnatt view... the bottom row cuts off then half of the line is shown at the top of the next page. I have adjusted the margins and information included in the header/footers but it still cuts off the bottom row. Any suggestions?
-
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…
-
How to use if cycle ... getting #INVALID OPERATION message
Hi, I'm trying to use a formula: if workcomplete is less then 100% then look for "process engineer" where Health matches "On Time", so formula would be the following: =IF(([% Work Complete]4:[% Work Complete]245 < 1), LOOKUP(Health4:Health245, "Process Engineering", Health4:Health245, "On Time")) I keep getting #INVALID…
-
How to Admin via Mobile App
I'm traveling and my laptop is fried. I have no choice but to use the iPad app version of Smartsheet. I need to remove several users from my sheets. But I cannot find a way to do that via the app. Does anyone know how to do that?
-
Microsoft Flow - Inserting a new row on a sheet with Dependencies enabled
Hi, I'm currently trying this out to see if we might use it more widely in my organization. I'm trying to insert a row using Microsoft Flow, but I am receiving the following error: * End Dates on dependency-enabled sheets cannot be created/updated. Please update either the Duration or Start Date column. Based on another…
-
Web Form session time
Hello, Is there a save-what-I-have-typed-in function in web form? for example, I didn't finish the web form at once, maybe, I left in the middle of it. When I come back to it, can I still use the same web form, and when I click submit, can this form be submitted successfully? I know this is a strange question, and I…
-
Undo Sort
Hello, Is there any way that an old version of a smartsheet can be accesses? Someone has sorted a smartsheet that was not set up for sorting and it is now unusable. Any way that I can undo the sort? Thanks!
-
Delete all comments and data of a sheet
Hi, how can I delete all comments for all rows in one go for a sheet? Thanks