-
Global Setting for Gantt Timescale: open to today's date
This setting "Open to today's date" should be global, so it is working for all persons who view the dashboard. If this setting is set, I see the Gantt in the dashboard on the actual date. If it is not set, I see the Gantt in the dashboard on the first date ever in the Gantt.
-
Formula to Summarize spending each week to display in a Dashboard
Hello, I have a large sheet that we use for procurement for our company. Employees use a form to requisition items, and then when I place the order for them I input the date ordered into a column. Another column tracks the cost of each order. I would like to have a formula that uses the "Ordered Date" column to add up the…
-
I am unable to find the right formula to checkbox in a column?
Sheet 1 - I receive project feedback for various projects based on project ID numbers and names. This is the sheet I want to pull data from. Sheet 2 - This where I need to track whether feedback is received or not based on a column checkbox to reference Sheet 1. Q1: What would be a good formula to pull data from Sheet 1 to…
-
Latest Comment Column - Default Name Doesn't Include Last Name.
Hi, How can I get the name that appears in the "Latest Comment" column to match the name in the "Assigned To" column? I have a helper "yes or no" column with a formula. The formula is set to enter yes if the latest comment is NOT the person in the "assigned to". Then, I use this helper column for a notification automation.…
-
Workflow Email Address Gets Blanked Out
I have built and successfully used a workflow for sending me an email when a specific condition in a sheet is met. Because automation is sheet-specific, I copied the associated sheet (I will eventually need 700+ of these) several times and discovered that the my email address is removed from the notification, resulting in…
-
Dynamic View and Contacts
I would like to share Dynamic View with some contacts but only certain contacts appear as options. Further, I cannot just add an e-mail address. How do I get all of the contacts pulled into that list? Thanks!
-
Is there a way to calculate age in years and months (4 years, 11 months for example)?
I have been able to calculate the age in years, but so far have not seen any other support questions to answer whether this can be done in years and months. Appreciate any help towards a solution, thank you!
-
Department capacity reporting
Hello, I'm trying to find an effective way to report capacity by department in a dashboard. For example, I have multiple departments working on several projects with different start/end months. What would be the best way to report on this in a dashboard?
-
Countifs Question
Greetings! How do I use the countifs formula to count if area =1, category 1 = x, and Date range is April? For the example below the value generated by the formula should be 1. How would I do the same but date range is all of April up to "today"?
-
Bounceback / incorrect email address validation
We use Smartsheet as a contract management tool and have alerts setup to send a notice to requesters / stakeholders when contracts are close to expiration. Unless we go through and manually update / check all of the line items, there's no way for us to know if the alert has been received or if it's bounced back / the…