Best Of
Re: Welcome to the online Smartsheet Community!
Hi @Ruby Gonzalez!
Thanks so much for letting me know, and sorry for the delay with your badge. You can now find the Fully Charged badge on your profile! 😄
Rebeca S.
Re: Function for "current user" to use in formula?
Excellent!
Upvoted! ⬆️
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Best way to preserve indexed historical data through versioning?
I just improved my initial idea. Here's what I'm thinking now.
- Adding a "Version" column to my helper sheet (see screenshot #2 above)
- Adding a "Version" column to my tracking sheet
, which will use a complex =IF formula that assigns a version based on the date - Using an automation to record the appropriate journey version for each new item (screenshot below)*
- Adding an additional criterion to my =INDEX(COLLECT) formula so that it matches the current version
*The automation will have to be manually updated whenever a journey evolves, but this doesn't introduce any manual updating where it didn't already exist; an =IF formula would also have to be updated manually, and it would be significantly more complex.
Zach_
Re: Column Type Reverts to Dropdown List
This issue in Smartsheet—where a column keeps reverting from a Check Box type back to a Dropdown list, especially when it's formula-driven—can be caused by a few subtle factors. Here are some possibilities to investigate:
1. Formula Behavior and Column Type Conflicts
If the column contains a formula that references a checkbox column in another sheet, Smartsheet expects the data type to match. If the formula returns anything other than true/false, Smartsheet may automatically change the column type to accommodate the returned value (e.g., text or dropdown).
- Check the formula output: Ensure it only returns
trueorfalse. Even a stray space or text string like"TRUE"(in quotes) can cause issues. - Compare with working columns: Look at the formulas in the other columns that are behaving correctly. Are they structured differently?
2. External Data Sources or Integrations
Even if you don’t see any Data Shuttle or automation rules, consider:
- Connected Sheets or Reports: Is this sheet being updated by a report or another sheet via cell linking or cross-sheet formulas?
- Third-party integrations: Tools like Zapier, Power Automate, or API scripts might be modifying the column type silently.
3. Sheet or Column Template Behavior
If the sheet was created from a template or is part of a Control Center blueprint, it might be inheriting settings that override manual changes.
- Check if the sheet is part of a portfolio or program managed by Control Center.
- Look for update requests or template syncs that might be resetting the column type.
Suggested Troubleshooting Steps
- Temporarily remove the formula from the column and manually set it to Check Box. See if it stays.
- Reapply the formula after confirming the column type sticks.
- Duplicate the sheet and test changes there to isolate the issue.
- Check sheet activity log (if available) to see what’s triggering the change.
I hope this helps!
David011
Re: Help Creating a Complex Report
HI @Hudson_Miller , I did!
I've actually just created a filter, available on all projects, that shows milestones at the top, regardless of date, with all other tasks still available underneath. This is probably the simplest solution for this team at the moment.
MWongInBeauty
Re: Sumifs total from two sheets - Errors
Hey Hudson.
You cracked it mate - thanks for that.
Jason P
Re: Project Metadata Sheet Not Correctly Indexing the Project Intake Sheet
I found a solution from another community post. The problem is not with the formula; however, it is with the references. Hover over the Project Name cell in the Project Metadata sheet and you will see a formula (fx) appear in a semitransparent rectangle below the cell. In the rectangle, you will see the following:
Edit Reference: {Portfolio Summary Data}, {Project ID} and {Portfolio Summary Header Row}
Click on {Portfolio Summary Data} and follow these steps:
In the Project Metadata sheet, modify the formula references as follows; references should be to the Project Intake Sheet. If you get any error messages or pop-ups, you may close them to continue.
- {Portfolio Summary Data}, - SELECT THE ENTIRE SHEET as the reference. You can do this by selecting all columns.
- {Project ID}, - Select the entire Project ID column as Reference.
- {Portfolio Summary Header Row} - YOU MUST HAVE A HEADER ROW - (Row 1) - that exactly matches the column names in both sheets.
Save these updates to the Template Set so that you don't have to do it on every project that is created from the Template Set.
I hope this helps.
DL Milton