Education
Discussion List
-
Remove Primary Column From ReportIn Using SmartsheetI am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
Countif and HAS for multiselect for Quiz answersIn Formulas and FunctionsI am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure …
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Can this excel formula be created in smartsheet?In Formulas and Functions=IFS(A5>B5+C5,"RED",B5>A5+C5,"Green",C5>B5+A5,"Yellow") If anyone can help me I<d be very appreciative :)
-
Automated Workflows LimitIn Using SmartsheetHi Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.
-
Flagging a Date and Time OverlapIn Formulas and FunctionsHello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
-
Smartsheet University Is Here!In General AnnouncementsHi Community, We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful con…
-
CountIf with Date rangeIn Formulas and FunctionsI am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
-
Line chart with multiple date-numbers tracesIn Using SmartsheetHello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…Answered - Pending Review 2.4K views 25 comments 1 point Most recent by James Vandezande Using Smartsheet
-
Free Webinar: Intro to Data ShuttleIn General AnnouncementsJoin us on January 19th for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use. We will be hostin…
