-
I can not figure out what is wrong with my CountIFs formula
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$") It works great. However, I…
-
How to edit Title in Calendar App?
Hi! Is there a way I could edit the Title of a calendar I created in Calendar App? I do not want to start over and create a new one just for the new title hence wanting to know if just the title could be edited. I am able to edit all other configuration through 'Settings' but just not the title. Am I missing something?
-
Workload Tracking - Delete Unwanted Archived Content?
I'm experimenting with Workload Tracking and seeing a relic in the heatmap I would like to remove from view as it skews the information. Would love some help if anyone has any suggestions on a fix. I want to share this functionality with my organization's leadership but am unable to if the information isn't meaningful. I…
-
Collaborator Count
In March '24 we switched from Chrome to EDGE. Before I was able to see the # of collaborators in any Sheet, but now in EDGE the count is missing… I learned that this function no longer works in either browser, but hovering over Share reveals the count. Now recently, I discovered hovering over the Share button no longer…
-
How to access Core App Path Self-Paced eLearning courses?
I'm a licensed user and preparing for the Core Product Certification Exam (which I have purchased). I prefer the "Core App Path Self-Paced eLearning" as a guided preparation (versus this) but only 1 "welcome" course is showing up on my end: After completing this course, I clicked "next course" and got this notification:…
-
How to notify form submitter that their request was approved/denied?
Hi, I have made a smartsheet form for travel requests. I would like to notify the submitter of the form when their request is either approved or denied. I made a column for "Employee Email" as a contact list. I have also created an automation for the approvers, but if I click on "Alert Someone" when the request is…
-
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!