I have an existing sheet with a lot of information in it. I would like to create a template to populate based of the information in my existing sheet. Then I would like to be able to print or export t…
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I…
I am trying to share a sheet with a colleague. I set him as a Viewer and sent him the link. He is being prompted to log in. This person does not have a Smartsheet license and just needs view only acce…
I have a multi-step workflow approval set up. Form entry submission sends an initial request to the manager. When manager approves, next approval goes to center administrator. Once that's submitted, t…
I am trying to populate an Actual Start Date field with the current date when a checkbox is checked (Task Started). I am using the TODAY feature in my formula for my Actual Start Date. But what I am s…
I am working with a consultant who does not want to create a Smartsheet account. Is there any way to share a sheet with someone and allow them edit the sheet without forcing them to create a Smartshee…
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fisca…
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on th…
Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the…
Today's my first day using Smartsheet; I referenced another sheet for columns that I needed. Now rows that are not found in my specified range are auto populated with "#NO MATCH." I need guidance for …