-
% complete based on count of child checkboxes.
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 have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Sharing a sheet - viewer is prompted for a login
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 access to the sheet. Can you please help me figure out how to fix this? I thought perhaps the problem was that the sheet was…
-
Smartsheet overrides workflow approval
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, then it goes to one more and then the director. Problem is that smartsheet is overriding the "Approved" status from…
-
Populating a Date field
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 seeing that when I open my sheet it populates all of those dates with TODAY's date so I loose the actual date that the task…
-
Can you share sheets with non Smartsheet users?
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 Smartsheet account?
-
#INVALID DATA TYPE formula Return
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 Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
-
Best way to calculate stats on a sheet tracking form submissions
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 the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…
-
Undo question
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 sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.
-
Referencing another sheet using vlookup
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 making the "no match" blank. I tried an if statement but still having the same issue.
-
Successor Column
Hello, Could the SmartSheet community get an update on the successor column from the products team? I believe this was first requested a few years ago in late 2015 and has been by others multiple times since then. Thanks, Riley
