-
AI text summary of a sheet progress/changes
Imagine you are a project manager, managing multiple projects/sheets. You have set up a dashboard that aggregates information from said projects. To make things easy to your CEO and other stakeholders, you'd like to generate a 500 word status report for each project that can be included per project on the dashboard via a…
-
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
-
Allow formulas in Assigned To when Resource Management is enabled
Currently, with dependencies enabled the Start, Finish, Duration fields do not accept formulas. Additionally with RM enabled (including the new Resource Heatmap), Assigned To can no longer be formula driven. Use case: when our Marketing team generates a copy of their campaign sheet, they have a number of pre-set tasks that…
-
Embedding from the Calendar App
Is there a way to embed a calendar you created from the calendar app without placing it as a widget in a dashboard?
-
Recover Data Shuttle workflows
For large organizations, allow Admins to recover the sheets, automation workflows and data shuttle workflows created by users who have left the organization and assign them to other users who took over the respective role. Currently, the only option is to start over, which involves not only time and labor, but also…
-
Sorting by Grouped Status with a custom order
I'm working on a report that has the usual project status "On track, Paused, On hold, In Queue, Delayed Start" etc… I currently have a list of the project name as a line item, then grouped by applicable status. That said, when "sorting", it doesn't give me the option to see which goes at the top or at the bottom, and…
-
Workflow to PDF
Hi, I am trying to figure out how to take data and pictures submitted via a smartsheet form and have it automate into a formated PDF. It seemed like there was a workflow that would allow this, but I am struggling on making it happen.
-
What's best practice for managing multiple variations for a date?
I'm working on a sheet where we need to capture several variations for each of 3 date columns (e.g., Drafted Date, Reviewed Date, Approved Date, etc.). For each of those dates, I need to capture the baseline, best case, worst case, current estimate, and actual. As you can imagine, it's a bit unwieldy visually and a little…
-
Checklist
I work at a construction company that installs windows/doors for residential homes. We currently us a checklist in our current system. The checklist is use by both installers in the field as well as office team members. Any suggestions on how I can incorporate a similar checklist in Smartsheet?