-
Trying to Figure Out Scripts
Hey all! I must preface this by specifying that I am a complete newb when it comes to Smartsheet. I know the very absolutely basics, but am now trying to learn more about it. The issue I'm trying to figure out is keeping track of multiple packages I send out a week. I wanted to see if there's a way to write a script where…
-
Help to select a value based on row number
Hi all - I am trying to determine if a task is ready to start based on all of the predecessors being 100% complete. I have numerous tasks with more than 1 predecessor and I've parsed out all the predecessors into individual columns (pred_1, pred_2, etc) like this I'd like for the ready to start column to indicate yes, if…
-
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.
-
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: 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.
-
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.