Other
Discussion List
-
Rows will not stay in place. NEED HELP NOWIn Using SmartsheetWe use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…
-
Need Help with Formula for Rolling MetricsIn Formulas and FunctionsI am working on a 6 months rolling metrics calculation for a point system. A simple data involved will be as follows: 1) Date column 2) Points column (0-10) 3) Name column I need to calculate a 6 months rolling sum of points, for e…
-
Relating sheets many to manyIn Using SmartsheetHi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two she…
-
Nonprofit looking for assistance expanding template setIn Using SmartsheetHello All, I'm in Operations at a nonprofit. I am hoping for assistance in building out the Template Set for Objective and Key Results (OKR) Tracker. The template set is built for 5 objective. I need it built out for 12 and I am running…
-
Bulk Removal of UsersIn Using SmartsheetHello, Just wanting to check if there's a way of bulk removing of Smartsheet users? I know you can bulk upload contacts/users into Smartsheet but need to know if you can do the same by removing. The reason for this is to avoid a long wind…
-
COUNTIF Formula for Contact ColumnIn Formulas and FunctionsI have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
-
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…
-
Formula for percent match to a multi select columnIn Formulas and FunctionsHi, I'm working matching mentors and mentees. We would like to match them based on attributes they both selected in a multi select column. As in, choose your top three competencies. Now I would like to make a formula to determine the pe…
-
Task duration based on allocationIn Using SmartsheetI'm using resource allocation to calculate schedule duration but the schedule isn't updating to reflect the allocation. Why didn't resource allocation (other than 100%) change task duration?
-
Timeline end date not updating correctly - help neededIn Using SmartsheetHi, I'm having an issue with my end date at the top not updating correctly. I have all the subtasks below indented correctly; however, it will not reflect that at the top most level. Please see the photo attached. I added in a new line at …
