-
Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
-
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
-
Comment Sorting
It would be nice to sort comments. For example in google, you can select only comments "For You". I would also like to "resolve" comments like in google so they are hidden once not needed. sorting by active vs. resolved would be nice too. or sorting by another user. Lots could be done here.
-
Copying Workflows between Sheets
In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is assigned to me the line is automatically copied to another sheet that is actually my Kanban Board so in one place I can see…
-
Self Pace Formula session not working entering information
I have completed 4 of the self paced lesson on Smartsheet core. The 4th Lesson, Formulas, the system will not recognize my clicking, entering the required information. I use Chrome - cleared browser cache etc. Tried Firefox. My default computer is a Mac - also tried it on a PC...any ideas?
-
Count of all rows that do NOT have a completed status
I'm trying to get a count of all cases that are not complete (aka open), to use on a dashboard metric widget. Eventually I'd probably like to be able to have a metric widget showing the count of cases that are in each status EXCEPT complete. I've dug around on the communities and I can't seem to get it to work. This is…
-
Bridge Workflow Error Notification
I'd like the option to detect errors and trigger a notification to myself when a Bridge Workflow stops. This would be particularly useful when running a child workflow as the entire parent and all subsequent children workflows will stop running if an error occurs. It would be nice to know that I need to retrigger my parent…
-
Smarthseet Community Feedback Dashboard
What about using a dashboard to find and upvote existing ideas? One URL for users to access a Dashboard that visually divides into Functional Areas, sub areas: Users could click on a topic of interest, see the contenders in order of votes, and add their two cents. I want to know: What are the most asked for ideas? Do I…
-
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…
-
"last/newest comment" column: prevent misuse
Hello to all, suggestion for the "last/newest comment" column (sorry, we use the German version so I do not know the correct English translation): Either lock the colum to prevent direct input of data, or add/append new input in "Conversation" section. It often happens that people contribute to conversations by typing…