-
Generating previous quarter from current date
Hi there, I am trying to get a formula that will generate what the previous quarter is for our fiscal year which starts in October. So for today April 2024 which is in our Q3, the previous Quarter would be FY24 Q2. If we were in October 2023, the previous Quarter would be FY23 Q4. If we were in January 2024, the previous…
-
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.
-
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…
-
Can't find sheets assigned to new user
hello, Personnel changes. Need to move assets from current user to his/her replacement. 1- Created new user 2- Transferred owner permissions and owned groups to new user 3- Deactivated old user On new user profile, i run "Sheet access report" and see the 2 sheets he/she has inherited. The new user cannot see these nor i…
-
Stellen Sie sich vor und lernen Sie Ihre Kollegen kennen!
Hallo, lernen Sie andere Mitglieder der Community kennen und nehmen Sie sich die Zeit, sich unten in den Kommentaren vorzustellen. Ihnen fehlen die Worte und Sie brauchen ein wenig Inspiration? Erzählen Sie uns, woher Sie kommen, welchen Beruf Sie ausüben, wie Sie Smartsheet nutzen oder nutzen möchten und den ein oder…