-
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…
-
Populating Drop Down list from column of entries in another sheet
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry in, I could have a list of clients to choose from. The next step, would be to post…
-
Link row cells (several at the time) from the resource sheet into a column on the destination sheet
How can I link a group of cells on a row to populate in a column ? Resource sheet Destination sheet (ignore the numbers)