-
Pull data from a source sheet to a destination sheet with one condition
Hi there. I have an issue and I would like your help please! You can find below the Smartsheet I have: I have a 1st Smartsheet "Source Smartsheet". In this Smartsheet, I have a list of projects with one line per project and multiple columns that are used to save the data for each project. I have one unique ID per project…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
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…
