-
Metric format in dashboard
I am trying to display a date in a metric on a dashboard, all the sheets have the date displaying DD/MMM/YYYY but the metric displays DD/MM/YY. How do I get the metric to display the date in the format that I desire?
-
Re-Title Notification Header
I recently used one of the existing templates "Contract Management" under the Client and Customers in the Solution Center, and it worked great. However, When my users get a notification the header still shows the old name (see attached). Please let me know how to make this change.
-
Using CHILDREN(cell address) as a range in SUMIFS
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the formula in the % Complete column. I am trying to use CHILDREN(cell address) as a range. What I have read leads me to believe…
-
Can a Report Display Project Dependencies?
Hi, I created a grid, with each row in the grid representing an individual project. I set the predecessors between the various rows, so Smartsheet draws the links between the various projects. I need to show this grid, including links between projects, on a dashboard. So I created a report using the grid as the source, but…
-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
DataMesh & Gantt Charts
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
-
% complete is not rolling up from child to parent.
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from the children. I attempted to fix it by creating a new % completed column and entering the values by hand. When I entered the…
-
Is there a way to merge two Enterprise Account Users?
Currently there are two Enterprise Accounts created for some reason. So I am unable to add an Enterprise User from 'Enterprise Account A' through our User Management in 'Enterprise Account B'. As per instructions, if we delete these users from 'Enterprise Account A': 1. Will their Licensed User license be removed from…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
