-
Index/Match vertical Report
Hello, I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This forms feed into a sheet that has 74 potential columns of information. As you can imagine, it is too large to really see…
-
How can I find all active notifications and workflows in a workspace?
I have a prolific workspace for a completed project that belong to another user who is no longer using the sheets but still owns admin rights. There are still some live automated notifications and line specific update requests being sent from sheets in this workspace. Is there a way to find them to get them shut off…
-
Automation to Sort Sheet at Predetermined Time
Good Day Smart Sheets community, I have a few automation notifications that are ran each Monday Morning at 6AM based off of an Est. Install Date column. I would like the rows to be listed in chronological order from top to bottom in the notification email. It seems the only way to do this is to have the sheet sorted in…
-
Average with a Criteria
I am looking to generate the average age of graduate students for each year. What was the average age of the student body for class of 2022 for example? How do I do this? I tried this: =AVERAGEIF({Students Range 6},, {Students Range 5}, "2022") Student range 6 are the list of ages. Student range 5 is the academic…
-
Report with both Null and Not-Null values
Hi all. I have been bumping my head against a wall on this one for over a week. I am pretty sure there is a way to get this to work but do not have the Smartsheet skill set to figure it out. Problem: The dashboard is not displaying the statuses with the correct bar chart coloring. How to do a report so it displays all…
-
Formula to Capture Tasks Starting in the Next 7 Days
I need to capture the count of tasks starting in the next 7 days that are marked as Not Started. Currently anytime I change the Status to Not Started my formula grabs it. So the task will be in the past but the formula is still counting it. Below is the formula I have, I can't get my head around it, any help is welcome.…
-
Help with Join/Collect/Has formula
Hi there, I'm trying to use join collect to gather data that has certain info in the "collect" sheet. I have figured out the formula, but i need to put a space between items and i'm not sure how to do that. the formula i'm using is in blue above this is what it's returning, i would like a space between thing 1 and thing 2
-
Time Tracking Template
I am going to be moving warehouse contents from one location to another over an hour away. I only have so many trucks and they can only drive so many hours. I need to track the time progress of each truck's load, travel, and unload, as well as shelving setup times while making sure that I can make adjustments on the fly if…
-
Reference a date in a non date column
Hi SS peeps, I am trying to reference a date in a text column by using the date function but it's not working. =SUMIFS({Employee 1}, {Employee Date of Sep}, >[Jan 5th]45, {Title}, {Lead Sider}) I've tried using =SUMIFS({Employee 1}, {Employee Date of Sep}, >Date([Jan 5th]45), {Title}, {Lead Sider}) I'm basically wanting to…
-
Formula Suggestions
I have to apply different calculations to certain columns, and after changes from the department, I'll have to modify the formula. How can I make this situation work? Is it possible to use two different formulas in the same column? Thank you in advance!
