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…
Our teams love to communicate updates on their Smartsheets, but I'm wondering what the options are to copy/export these conversations and attachments. We'd like to archive the information into the pro…
Advice is greatly appreciated. =SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", CONTAINS({Alpine Master Range 1} "Chasse", @cell))
I created a QR Code using a Smartsheet Form URL; however, the QR Code takes me to a Smartsheet sign-up page instead of the form. I tested this with several QR Code generators. Any idea of what's happe…