Best Of
Re: Formula to flag required approvals and if they've been obtained
@Lauren Lederle When you are using @row you do not need to hyphen. As the range is literally the column in the same row your looking at. You only need to column:column if you are searching the entire column for some information
Mark.poole
Re: Formula to flag required approvals and if they've been obtained
=IF(AND(CONTAINS("CLT", [Reviews and Approvals Needed]@row), ISDATE([Conservation Leadership Team (CLT) Review Status]@row)), "Approved", IF(AND(CONTAINS("CLT", [Reviews and Approvals Needed]@row), ISBLANK([Conservation Leadership Team (CLT) Review Status]@row)), "Pending", "N/A"))
Mark.poole
Re: Using Index/Match to pull column names where values =1
Is my best workaround to add in a new row 1 with all of the column names listed (the titles of the Learning Courses) & Index that info where my ID numbers match & a 1 is entered in that particular column?
iamsteve
Re: Using Index/Match to pull column names where values =1
After working on this the past 4 hours, I realized that I can't pull column names, & potentially multiple column names using index/match, or any formula for that matter...unless I am mistaken? So I reluctantly pulled the data from each & every Learning Course using index/matching to the ID numbers on my secondary sheet. Now I have the data I need, organized the way I need it, to pass up the ladder.
Thank you anyways Paul 🙏
I'm sure I will need some expert assistance soon enough!
iamsteve
Re: Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I'm not quite sure how the VLOOKUP or INDEX/MATCH cross-sheet formula would work, since I assume something needs to exist first for it to MATCH to. Or is there a Column formula that can be written that is something along the line of "make sure the first column on training sheet matches the first column on the names sheet", and would then update in the training sheet if a new name is added to the names sheet?
It's easy enough to pull the information I need over once there is something for it to MATCH against, like the UserID or email, but getting a new User ID to copy without having anything to reference it against seems like MATCH couldn't work with it?
Di Mueller
Re: Select which columns to copy or move from one sheet to another
I love the automation to move over rows automatically, but being able to choose which columns data is moved from would be ideal.
We use a sheet to track our recruitment efforts (with interview dates and other information) but when we hire someone, we don't need all the misc. dates and information to come into our current employee sheet.
JRudd
Re: Dark Mode for Desktop App
Is there or could there be a dark mode? My eyes are killing me with the super bright white screen.
DWilliams
Amendment to Contractor/Project Editor Permissions within Resource Management
One of the limitations of the Contractor security permissions within Smartsheet is that a user is unable to "split" their allocation as they do not have access to Schedule view.
However, to give them access they would need to be upgraded to Project Editor, but this then means they have full visibility of capacity for everyone within the organisation.
There should be an option to upgrade a user to similar permissions, but so that they can only see their data, or the data of individuals in the same Discipline (their own team).
This potentially limits the use of Resource Management for us, and possibly other organisations for whom data security and the principle of lowest permissions first are key.
jamieclarksdx
Preserve Email Format When PopulatingMulti-Contact Columns
Description:
In Smartsheet, when a Contact column (that allows multiple contacts per cell) is populated using a cell reference containing an email address, the value displayed in the target cell is automatically converted into a display name.
Problem: This behavior causes a disparity between the input and output data when ingesting this data in a dataflow:
- The source column contains a clean email address (e.g., user@example.com).
- The target column, when allowing multiple contacts, converts this to a display name, not preserving the original email address.
- As a result, it's not possible to reliably extract or reference the actual email addresses for reporting, automation, or integrations.
Feature Request:
Please provide an option or formula that allows users to preserve and extract the official email address from Contact columns, especially when:
- The destination Contact column allows multiple values.
- The source is a single email address entered or referenced dynamically.
This would ensure data consistency and greatly improve usability in automation and reporting workflows.
Thank you for considering this improvement! Please do it ASAP and let us know.
CamiloLozada