-
Collapse and Expand
Is there anyway to stop the sheet from expanding all children every time someone goes into the sheet? Annoying is all. Thanks in advance for any advice.
-
Show sheet data in the Form View
Our PMO is using Smartsheet to intake project requests from the business users via our intake form - which we love. However, once the project is submitted there is no particularly good way to have the request data that is in the sheet visible back to the business users (requestor, project owner, executive sponsors,…
-
How do I extract first and last name from an email address in proper form?
Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying to do.
-
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: But understandably, it doesn't tell you how to create it. From what I can tell it requires a sheet, form, calendar app, dynamic view, and a dashboard to bring it all…
-
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.
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
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.
