Smartsheet Basics
Archives for July 2022
Discussion List
- 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…
Trending in Smartsheet Basics
- Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day …
- It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
- This discussion was created from comments split from: How to add logo in smartsheet Forms?.
