-
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
-
Aligning week number to financial year
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
-
R package for Smartsheet
HI, Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet? I am considering a project using R and I might start building out a package. Thanks Craig info@ngsanalytics.com www.ngsanalytics.com
-
About product (Smartsheet Business plan)
Describe any audit trails that are in place to monitor who is accessing which data? How long the logs are stored? How quickly could Smartsheet restore users data (without alteration) from a back-up if Smartsheet suffered a major data loss? What is Smartsheet RTO and RPO please? Please provide details of any exclusions to…
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.
-
Resource Management: Improve View of Time & Fee Categories in Settings
In the settings, the Time & Fee Categories view chops off the end of Categories with longer names. There is so much space on the page, it does not make sense why the full name of the category would not be visible. Something like "Example Long Category Name" would be listed as "Example Long Ca..."
-
Putting AI to Work: What’s Next for Smartsheet ⏭️ Join our upcoming webinar
When it comes to AI, we’ve been hard at work. Back in March Ben Canning, SVP of Product Management shared how generative AI will enable Smartsheet users to be even more effective and in April you joined the conversation, sharing how you would like to see generative AI applied to help you do more with Smartsheet. We're…
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…