-
SUMIF IF referred sheet/column ISDATE
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
-
Bug: Nuisance message on opening published editable sheet
When I open a Published Sheet (Editable), I get the dialog box shown. Please make it stop. Craig
-
Linking action items to project tasks
Hello everybody, first time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smartsheet, so would appreciate help in getting a solution for my workflow I have a project sheet, with task names, start & finish dates, predecessors (dependencies enabled),…
-
Creating a Temple for Router Configrations
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 the information to create a router or switch configuration template. Sounds easy enough but have never done this and would to…
-
% 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?