Hi I’m having trouble linking a ‘RowID’ column (Auto number) in my master ‘Project Intake’ sheet to a target or secondary ‘Sponsor’ sheet column named ‘Sponsor Row ID’. I use the two Row ID columns to…
Hi. I am wanting to use a formula or automation to change cell value between sheets. Ie, I have a Machine Checklist sheet that is populated via a form that my employees fill out pre-start on a machine…
Hello, I'm looking for a formula/solution that would count all the correct answers at a row level. If the answer is wrong then it wouldn't count it. Any suggestions? Maybe Conditional Formatting to de…
Is it possible to create a project template with ALL possibilities/steps/options and then when we need to create a new project, we can select what steps or parent rows need to go in that particular pr…
Does anyone out there have a tried and true construction bid comparison solution they'd be willing to share? Looking to make automation from Bid Tracking/Comparison/Scope Coverage to Contracting and h…
I'm using an Assign people automation to fill in contacts for several roles based on criteria or check boxes entered on a form. Each condition path should add a name to a different cell. It's only add…
Does the allocation % column work? I'm finding that for one of my coworkers it is saying she is over-allocated even when her allocation is only 60%. 20% for three projects all given the same time. Cou…
I've set up an automated workflow to send an email to our team when specific cells have changed (a contract's name & billing code are entered in separate cells). These cells are on different rows. I'd…
Title says all. I'm trying to clean up stale data out of Smartsheets and store offline as the data is no longer relevant for stakeholders, however I want to keep a record of said data, just not in Sma…
Hi Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, t…
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the dat…
In the Project Management Learning Path via Smartsheet University, I'm running into an issue where it will not allow me to run the 'Regular Task Update Request' weekly on Monday, Wednesday, and Friday…
