-
Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
-
PMO Template - Porject Intake Sheet - Schedule and Project Status
So i have downloaded and setup the PMO and modified a fair little bit and am liking it as a whole. However, it does not seem like the Schedule at Risk and Project Status are linking back into this. It looks like they should grab from the project metadata for each job and display it here, but i can only manually go link to…
-
Is there a way to open the a gantt chart to today in a dashboard view?
The dashboard widget is pulling from a report, which I have updated the project settings to open on today's date. But the view within the dashboard isn't opening on today's date. Any way to update this?
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
% Variance between 2 numbers
I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
Printable and Readable A3 Gantt Chart
Hello, Could anyone advise on how to print a readable gantt chart in A3 format? I've managed to export it to PDF and select the rows needed, however it is barely legible. Exporting to excel has not helped as it deletes the gantt format. Would be grateful for any tips or solutions! Thanks
-
Deadline based on Priority dropdown menu
Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the…
-
COUNTIFS + CONTAINS + OR Formula
Hello - Looking for some assistance on a cross sheet formula. What I'm trying to calculate is how many Level 2 rows display a specific project manager name from a multi-select column type. There are several rows with more than one name. Additionally, I want the formula to count all projects that have High, Medium, or Low…
-
Hide columns from Published Public View?
Is it possible to hide columns from the public view once a Smartsheet has been published? I thought it was possible, but I can't figure it out now. We sent out an automation to have different people update their rows for a directory. There are 1-2 columns that are just for our team on the backend (additional comments,…
-
Project Template
Is it possible to create a project template with ALL possibilities/steps/options and then when we need to create a new project, we can select what steps or parent rows need to go in that particular project? If so, how is that done?
