-
Column Naming, Navigation, & Preview, similar to Tableau Prep and Power Query directly in Sheets
Can Smartsheet port most of the functionality from Power Query? It would thrill me if two features I use all the time in Power Query could be added "remove blank rows" and "Use first Row as Headers" so I would never need to manually rename a column again. I'd also love if SmartSheet had the Choose Column, Go to Column…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
-
Unique dropdown values in cells from linked sheets?
I want to create a unique dropdown menu based on a link from another sheet. On the linked sheet, one column will have a list of IDs and the second column will have a names that are associated with one type of ID. Each name has its own unique row, and IDs may appear multiple times for a group of names. The linkee(?) sheet…
-
Calculating average time spent in each phase
I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
-
Auto Populate Children Dates based on the parent first day of the month
Good evening - I am looking to create an auto date that maxes based on the month (i.e. 28 days in February or 30 days in September) based on the parent row. I originally had it by calendar year and organized by the Month as the parent, and that parent row has several values that are linked to other sheets, however, I was…
-
At Risk Formula that utilizes end date and status columns only...
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…
-
Setting up a sheet with names
How can I have a calculation sheet where all the names of the main project sheet will appear on, automatically? So for example, someone new has joined the project. They have a task now, on the main project sheet. I would like this person's name (so they are in the "assigned to" column) to show up on the calculation sheet…
-
How do I override a row in a secondary sheet when the info is updated in the master sheet?
I have a Master sheet where all of the data is stored. I also have other secondary sheets that have just the applicable columns for those groups of people. When I update a date or cell in the master sheet, is there a way to either just update that same column in the secondary sheet with the new info or copy the entire row…
-
Share sheets as hidden
When sharing a report that needs to be edited i also need to share the sheet onto the person editing. For some of my sheets this can cause GDPR concerns as i don't have sheets per company only sheets per process. (It would kill all efficiency to have to create a sheet per company for each process). If i could share the…