-
Count Multi-Select Options
Hi Community, I have a multi-select column where I need to count the number of values selected (just the total, not individually). Is there a formula to help with this? Below is a screenshot of my cell (Rollover) and the outcome I'm looking for (Months Rollover). Thank you as always! ~Jaime 😀
-
Meeting Room Booking System
Hello, Has anyone in the community ever developed a meeting room booking system with Smartsheets? I found an awesome system from Prodactive on YouTube at: https://www.youtube.com/watch?v=IT9Px8evy00 But understandably, it doesn't tell you how to create it. From what I can tell it requires a sheet, form, calendar app,…
-
Formula works in one sheet but not others (cross-refs are updated)
Hi there, I have a formula in one sheet, which looks at the task and calculates the dates for each task, excluding holidays and weekends. =IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupDerek}, 2, false), {TechTarget Holidays Range 2}), "") I then use this same formula…
-
Why can't I change the project name on the dashboard?
I am a new customer with the Pro plan but I am unable to change the Project Name on the Dashboard. It reads "Project Name in Summary Sheet", so I go to the Summary Sheet and it is grayed out with no option to edit. Please don't tell me I need to pay more to change the Project Name.
-
Merged: Freeze Rows/Columns
This discussion has been merged.
-
Why can I not see comment Icon on lines of my Smartsheets?
On my work computer @ the office comment icons when there is one on a certain line but from my phone or at home i can see when there is a comment? Can someone please help?? It's hard to do my job if these aren't visible to me.
-
Enable multiple views of same sheet within a workspace
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view version of that sheet. For my use case, the main sheet would live as a grid, then a calendar copy could be made that is locked…
-
Finding the earliest date from Children based on the status in other column
Hi all, I'm trying to find the earliest (Min) date from children based on the value in a different column. So if the value in Asset Status column is not "Completed", "Cancelled" or "On Hold", then consider those children and then find the earliest date(min) from them. The column where I'm trying to find the earliest date…
-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Progress with children rows
Hello all I have a tracking sheet for payments under several Purchase Orders (POs). Each PO can have different numbers of milestone payments—anywhere from one to ten or more—until the PO is completely paid. For each milestone, I need to mark it as 100% and then i need send invoice. The parent row should then show the…