- Document Builder - Adobe Calculated Fields
Hello community, I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script: var today = new Date(); event.value = util.printd("m/d/yyyy",…
- Stacked Column Perhaps?
On Hover (dashboard) I want to be able to see all the types of projects that each one has been assigned to through different colors. Kindly assist on how to go about this
- Reporting multiple criteria from multiple sheets
I am trying to create an output (maybe a report?) that shows multiple criteria from multiple sheets. I'd like to show each project (I have a sheet for each), with the assigned personnel by "task type" and "priority". I'm not really trying to do true resource loading. I just want to see number of tasks assigned to each…
- Improve how logic functions work with contact columns
If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…
- Archiving Project in Control Center Should Also Remove Project from Portfolio WorkApps
When you archive a project in control center, it does not remove the project from Portfolio WorkApps. This leads to confusion for project owners and others shared to the project when they still see their archived projects within WorkApps. The only way to remove a project from WorkApps is to delete the project from control…
- Smartsheets Countifs and Month filtering Error
Hello Smartsheets community, I am having some trouble with this code as I am not getting the answer I want. Any help would be appreciated! =COUNTIFS({CBOM - Yellowstone Range 1}, "N", {CBOM - Yellowstone Range 2}, "1", {CBOM - Yellowstone Range 8}, "MONTH(@cell) = 9") Thank you!
- Other options for viewing critical path
What other options do we have for viewing critical path? I'm in the Gantt view and have critical path turned on but my project is large and tracing the lines to try to figure it out is more of a maze and I still don't know what the critical path is. Is there an easier way to view this info, please???
- New solution panel makes collaboration even easier!
Hi Community, Our new Workspace solution panel makes building powerful, collaborative solutions in Smartsheet easier than ever. Our latest development incorporates your feedback and takes Workspaces to new heights with a left-hand panel that simplifies navigation enabling you to build, organize and tailor solutions so you…
- Running Sum of a column with a given Criteria
Looking for formula help to provide a running sum of all the guests registered to attend a function on a given day.
- EDIT TEMPLATE
How / Why can it be 2023 and we still cant edit a template.............SmartSheet your joking