-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Current User Report Filter to Include Group Memebers
I currently have a report that is filtered to show tasks assigned to the “Current User”. The Current User may have teams members who help them – say User A has three assistants. I would like the Report to allow the assistants to also see the tasks assigned to User A. There are multiple Users who have assistants…
-
Deployment roadmap
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?
-
Why is my progress not being completed?
Hi everyone! I am having trouble advancing in my course because for some reason I have 2 modules that do not mark as "complete", could someone help me out with this?
-
Notification and Access Issue
Hi everyone, I’m seeing an inconsistency with notifications in Smartsheet and wanted to check if anyone else has encountered this. We have two users working in the same RAID log sheet. Both users are posting comments in the Conversations panel and tagging others on specific RAID items. For one user, tagging works as…
-
Mentions stopped working
Hello. My sheet has been sending mentions since it was created long ago. People within and outside my organization have access and all have gotten the mention emails. In April the mentions stopped sending. I did some research and everything pointed to personal settings or spam filter blocking. Both have been checked and…
-
Automation to Combine Multiple Row Attachments into a Single PDF
I’d love to see a feature or automation added to Smartsheet that allows users to automatically combine multiple PDF attachments into a single PDF. Use Case: I have a Smartsheet where we collect applications, and each application includes several supporting documents uploaded as individual row-level PDF attachments. When…
-
MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?