-
Hello!
I've been trying to count how many milestones called "Testing" with %Complete = 100% are per project. Each milestone is a child of a parent called "Milestone" and this is at the same time a child of the project …
Using Smartsheet244
FrankOrtz
-
Hi all!
New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Shee…
Formulas and Functions20
Alex Zylka
-
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July"…
Using Smartsheet17
mconne17101921
-
Hello 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…
Using Smartsheet527
Jakub Gill
-
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
Using Smartsheet76
Shah_0614
-
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet60
Mary Vogt
-
Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share?
TiA!
Using Smartsheet35
Michael Maxson
-
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
The New Work/Life Reality3251
Dana Esquivel
-
I am an administrator in Dynamic View and have created a new view. I want my staff to be allowed to submit new items. I have selected that as an option but cannot figure out how to have them actually add a new line. Help!
Using Smartsheet46
lomorse
-
IT departments must take the lead on pandemic response planning...
Your Challenge
COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available inf…
The New Work/Life Reality153
Thurman Jones
-
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Da…
Formulas and Functions42
Danielle Maroon
-
Hello everyone,
Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no c…
Using Smartsheet24
Conner Sherman
-
Hi all,
I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet.
The strange t…
Using Smartsheet25
Gunn_Jack
-
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions290
EmilyH
-
I 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…
Formulas and Functions1280
lnelsen
-
Hello,
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…
Formulas and Functions138
MattSederquist
-
As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has…
Using Smartsheet47
sdonnelly
-
I 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!
Using Smartsheet334
Sgiovinazzo
-
We have a number of staff who are accessing Smartsheet, some as registered users under the Team plan, and many others who have free accounts and edit sheets shared with them.
On one user's computer, however, whether she logs in with he…
Using Smartsheet60
Vance McMillan
-
Hello everyone!
Hoping I can get some assistance from the Gurus around here.
Currently, we have an =IF formula that looks at the Due Date of a project and:
* if the project is today, it returns THIS WEEK
* if the project was last week,…
Formulas and Functions53
DiAlmeida
-
Is there any option to set a cell to be both inbound and outbound so that regardless of which sheet I update the cell, the two sheets will be updated? Thanks in advance.
Using Smartsheet52
leoatucsd
-
Hi All,
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions65
KDub618
-
Hi
I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong....
=COUNT…
Formulas and Functions43
Kate_
-
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts79
Michael.Baker
-
Hi
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 …
Formulas and Functions5092
lcamacho19911
-
Hello!
I am looking for help in building a formula for a sheet. I create semester reports on a sub-group of persons that we track in a master database. Because this database is extensive (multiple years) but my reports are created from…
Formulas and Functions61
kbrussel
-
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …
Formulas and Functions191
Serena Williams
-
I am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teac…
Formulas and Functions67
Kris Dysert
-
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200.
Any help is highly appreciated.
Thanks
Using Smartsheet34
sandeep-bonthu
