Best Of
Meet Carson Penticuff, our April Member Spotlight! 🎉
*takes a deep breath* 2, 4, 6, 8, who do we appreciate? It’s @Carson Penticuff, Community Champion and our April Member Spotlight! Read on to find out why he’s an all-around star and advocate for continuous learning, both on Community and off.
Carson lives in the US state of Kentucky, and works as a Project Management Specialist at Toyotetsu North America. When his company began migrating key systems to Smartsheet a few years ago, he read the documentation and realized that there were many other ways to utilize the product. Now, Carson says Smartsheet has become his go-to solution for simplifying complicated workflows and visualizing large datasets.
“One of my favorite features is the ease of linking and referencing data across multiple sheets and workspaces,” he says. “I have numerous reports that can be pulled into master dashboards in order to monitor data health and integrity. When I have a new metric that needs to be monitored, a new report can be built quickly and added to existing dashboards with only a few clicks, often adding new insight into existing data.”
With Smartsheet now a central part of his daily workflow, how did Carson ramp up his knowledge, eventually becoming a Community Champion? “Most of what I know about Smartsheet, I have learned from Community,” he says. “When I hit a knowledge roadblock, I am almost always able to find either a solution or a new approach with a quick search.”
Other than helping others and learning new Smartsheet releases and features, Carson has interests in many other areas, showing a curiosity and hunger for knowledge.
- He is currently studying Japanese, and hopes to one day hang out on that side of Community
- When he has spare time, he enjoys rewatching legacy science fiction TV shows from the 80s to the 2000s
- He is a retired competitive speedcuber (see photo above), and was a member of the US Nationals Organization Team for two years
Above all, Carson loves to spend time with his son. “Watching him grow up and show interest in the same activities I enjoyed at his age is like getting a second childhood,” he says.
Thank you Carson for all that you do!
Rebeca S.
Re: Formula for counting how many times a cell has been updated
Thanks!
✅ 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: Trouble with IF statement and date format conversion
The text column would mean that nothing is considered a date and can't be used as a date in further calcs without added complexity to convert. If you leave it as a date type column, you can use
=IF(ISDATE([Date Column]@row), [Date Column]@row, DATE(VALUE(RIGHT([Date Column]@row, 4)), VALUE(LEFT([Date Column]@row, 2)), 1))
Paul Newcome
Re: Task totals across multiple plans & within a set timeframe
Hi @melissalk
You can create a metric sheet to count the number of tasks by department and month with formulas like these;
[January] =COUNTIFS({Task Name}, ISTEXT(@cell), {Task Type}, "Task", {Actual Start Date}, <=DATE(2023, 1, 31), {Actual End Date}, >=DATE(2023, 1, 1), {Department}, Department@row)
[February] =COUNTIFS({Task Name}, ISTEXT(@cell), {Task Type}, "Task", {Actual Start Date}, <=DATE(2023, 2, 28), {Actual End Date}, >=DATE(2023, 2, 1), {Department}, Department@row)
Note:
- ISTEXT(@cell) condion can be NOT(ISBLANK(@cell)).
- To determine if a task belongs to a month, for example, February 2023, you can use this condition;
- {Actual Start Date}, <=DATE(2023, 2, 28), {Actual End Date}, >=DATE(2023, 2, 1)
- The avove is an AND condition that works for a task spanning over a month.
- For example, if a task starts in January and ends in March, the task is counted as a February task.
Re: Too many cross sheet references
Hello @Jenn123,
Just wanted to @mention you in case you missed the solution above!
Marcela
Smartsheet Intelligent Work Management and McLaren Formula 1
Smartsheet Community members from around the world are using Smartsheet Intelligent Work Management in ways that allow them to reduce friction, quiet distraction, and Work With Flow.
When individuals or teams Work With Flow, they work in a way that is efficient, intuitive and empowering. Rather than getting bogged down by complexities, they find rhythm. Being a Smartsheet customer means powering your flow with a simple, flexible platform, where even complex, high-stakes projects become clear, manageable, and surprisingly simple.
For the McLaren Formula 1 team, a successful car starts with over 14,000 meticulously crafted parts, perfectly tracked with Smartsheet. From engineering to production to assembly, AI-powered Intelligent Work Management helps bring every piece together seamlessly—with every part in place and every team member connected.
McLaren is just one of many customers achieving amazing results with Smartsheet—and we know you have a story, too. Tell us how you use Smartsheet to Work With Flow by sharing in the comments below, and we’ll thank you with a special badge for your Community profile.
Arsineh
Re: TODAY Formula
@Kayleigh Colon sending you a tag in case you missed the comment from Paul! 🙂
Genevieve P.
Re: TODAY Formula
I would suggest a sheet summary field containing something along the lines of
=INDEX([Total Hours]:[Total Hours], MATCH(TODAY(), Date:Date, 0))
Then reference the sheet summary field in your metrics widget.
Paul Newcome
Re: Welcome to the new AI Community!
Hi,I've been using Smartsheet for over 2 years.
I use the AI functionality in Smartsheet primarily to generate and troubleshoot formulas, which has been a life saver. I also use the analyze data tool to create quick charts or computations from my sheet.
I’m interested in learning how others are leveraging the functionality.



