-
Conditional Formula
What is the formula to use if I was to populate a value in one column if the Start date is today's date or later? Is this possible? So if the start date is todays date (for example) I would like the status column to change from a value of Planned to Current. Any ideas?
-
Parent/Child Rows
Hello I have built a production schedule for our assemblies in our shop. We have a parent line with the Job# and the assembly being built. We then have indented child rows under the parent row for all the individual components needed to build the parent line. We track if these items have been received by changing a column…
-
Error when trying to add a user within the company
Hi, I am trying to add a user through User Management, but I get this error: "The user you are trying to invite is in a Smartsheet Enterprise Plan. To invite and Enterprise user, please contact sales at...." Any help is appreciated. Thank you, Deepthi
-
Cannot embed Data Studio Report on dashboard
I trying to add a Google Data Studio report to a Smartsheet dashboard using the Web Content widget. The explanatory text says that it can be done, but the link is not recognised as being valid. How can I achieve the desired result?
-
Sumifs returning #INVALID DATA TYPE when referenced range contains a formula
I am creating a per week rollup that shows a sum of the children rows from another sheet. It looks to me like SUMIFS does not work if the range referenced contains a formula. Is this a bug, limitation, or do i have an error in my formula? =SUMIFS({ManpowerPerTaskApp}, {ManpowerWorkingStart}, WEEKNUMBER($Date@row) =…
-
Archiving - Not Using Control Center
Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. My boss has asked to remove the status notes except for the current month and saved…
-
Smartsheets back-up (as a Smartsheet and not Excel)
Hello community, I would like to know how, over time, to back-up different versions of a smartsheet. I can see there is an automatic back-up, which backs up the smartsheet as an Excel. In order to keep track of different versions (as the formulas), I would like to know if its possible to back up a smartsheet as a…
-
Using SUM function on a column that has IF formulas in the cells
Hoping someone can help me with this issue! Please see the attached screenshot. I'm having this issue on 4 columns but will use the "Visit Metric" column as an example. I want to SUM the values of all the cells in that column within a cell at the bottom of the sheet, =sum([Visit Metric]2:[Visit Metric]114). However, when I…
-
Cross Sheet Formulas For Children Rows
Hello. I´ve spent all day trying to look for how to do this, I found some info but wasn´t exactly what I needed, plus, I´m new using smartsheet. What I need is to bring info from another sheet, but only what is inside a children row. I have a budget sheet with several ancestor, parent and children rows; I need to use…
-
"Trace Dependents"
Hello Community, Excel has this "Trace Dependents" function which enables to know if (and where) a cell is refered in another cell formula. I can see that when a cell is further used in a smartsheet formula, the cell has tiny black/blue arrow. But I struggle to know the cell dependance. Any clue ? THanks
