-
Restricting end-users to download data on their mobile via mobile application
Restricting end-users to download data on their mobile via mobile application. How? Any insights would be helpful. Thank you.
-
How can i make a row automatically get created and updated in one sheet as it is created elsewere
Hello world! I am trying to create a overview sheet that will be fetching values from two different lists. The two data sheets have a identifier number for each row in them, but placed in differant coloumns were only in one of the sheets is this identifier the Primary coloumn, so automating copy and paste row to other…
-
Smartsheets Save Error
Hi, I am currently having a repeated error in saving the changes that I make to my smartsheet. It first occured when I was manually triggering an automation through a checkbox in a column to move to another sheet to house the filtered rows. I was able to move 26 rows by manually triggering each row, but on row 27 it showed…
-
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…