-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
sheet summary report not counting multiple different responses given in one cell
Hi all, I have a summary sheet report with fields drawing responses from surveys collected. The surveyed people were able to tick several possible answers in the surveys. These multiple responses appear in one cell, e.g. "how did you find the event?" and the answers are "fun, educational, accessible". I would like the…
-
Intake data-> Project Sheet...Why so difficult????????????????????????
All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…
-
Health column formula to automatically change based on due date
Hi all, Looking to get some help / formulas to help me with my sheet. I would like my health column to change colours automatically based on: Green = Status column marked completed Yellow = due date two days away from today Red = Due date in the past
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
Days Remaining until Due Date (minus weekends)
I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only. My original formula was: The formula I thought would work was this, but got a #invalid data type error: Any suggestions? Thank you!
-
Contact List Column auto-populating with org emails
Hey there - new(ish) to Smartsheet and in a bit of a pickle. I have a sheet with a Contact List column that I use to request updates from outside partners. However, when the update request is sent the Contact List column field (where they could update their contact email) features a drop-down of emails for all users in the…
-
SUMIF Formula with Checkbox Criteria
Hello, I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE... I can get around the issue with…
-
Formula to calculate the Next [Future] date in a string of dates
Hello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get the MIN Date, However, many columns are in the past. I want the next [future] date after…
-
Can't add a column to a sheet
I have the paid version (for years) of Smartsheet. For some reason on one of my sheets, I cannot add a column. Any help? Thanks! Jennifer