-
Help with Dates not spanning over days that are not being used.
So, as you can see there in the calendar view I have this meeting that occurs every Monthly Monday, but the end date for this meeting stops on 1/25/24. The issue that I'm having is how can I have this meeting show up only on Mondays every month until that end date. Also, I have a formula that is set up, and I have…
-
Clarification on "Save As New" limits
@Genevieve P. @Paul Newcome Hello Genevieve and Paul, Can you clarify the "Save As New" limits? Specifically, does the 100-item limit include ONLY sheets? Or does it include folders, sub-folders, reports, and dashboards as well as sheets? Or are folders excluded but all other types of assets included? I'm trying to plan…
-
Email being sent before Approval Request is answered?
I've set up automations based off of the type of request, division, division head, etc. The automation. The Trigger is when rows are added and when the Type of Request (in this case) is a PO, there is a stacked condition of when the Division is "Admin" and where the Contract is "No" When these conditions are met the…
-
Move automation is moving all items (not just the trigger)
I have a sheet that I want to move "complete" items to an archive sheet. I have done this with many other sheets, but for some reason when I set this up and run it- it moves all items (even those that don't meet the criteria) to the archive. I couldn't undo the incorrect move, and I couldn't even paste the info back in. I…
-
Receiving Attachments VIA Email
Can attachments be automatically added to the row through a return Automated Notification Email?
-
Project MetaData issue
I am using the PMO Template set and having an issue with the Project Metadat sheet connecting to the Dashboard. I've checked the project ID# from the intake sheet and it matches the metadata sheet for the project but is not pulling in some of the fields to the dashboard. Any suggestions?
-
SmartSheet Merge from Google Docs questions
I am running a SmartSheet Merge from Google Docs. In the Run Merge section, I am having two problems: In the Run Merge section when I select "Create PDFs" and "Upload to Row in Smartsheet," the PDFs are not actually updated. How can I fix that? Also in the Run Merge section, when I rename(using Change and then Save) the…
-
Vertical Axis Rounding Percentages Up In Stacked Column
I have a stacked column chart on a Dashboard. The categories are all percentages that should amount to ~100% when summed (stacked). The vertical axis seems to be rounding the percentages to whole numbers; you can see that the grid lines that should be 20% and 40% are both rounded down to 0, where the grid lines for 60% and…
-
Needing assistance with Parent/Child formula
Hello, I have set up a summary sheet, formula I am using - comes back #UNPARSEABLE =CHILDREN(SUMIFS({# of Crossings}, {Permit Type}, "VDOT", {Permit Status -}, "Permit being compiled" Any help very much appreciated,
-
Smartsheet Calendar - Render event to actual start & end dates
I'm creating a project visual-timeline using the Calendar App, but the tasks are spanning entire time periods instead of representing the actual task timeline. Phase 1 completes on Sep 1st, but it shows running through the entire month of September. Phase 2 starts on May 15th, but it shows starting on May 1st. How do I…
