-
Is there a way to show the report and give edit access to add comments and add attachments?
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked with the underlined sheet where my entire team works. V have information that shouldn't be shared with anyone outside the…
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
Duration to a specific task from project start / counting the number of project days
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For example, the first task would start on "project day 1," the last task of the project would start…
-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
-
Cut not working
Starting 7/30/18 we noticed that using either the keyboard shortcut or the right-click option to cut a line within a SmartSheet would sometimes leave behind the original line (acting more like copy than cut) when moving to a different place in the SmartSheet. Two people within our organization have recreated the problem.…
-
Prefill Form with a Date Column
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would…
-
How to re check many attachment file? When I backup data from Smartsheet.
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached to. I need to find a way of linking files to the original rows that the files were attached to. please help me.
-
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…