-
Any recommendations for third party form builders with advanced date field functionality?
I'm looking for a third party form builder that integrates well with Smartsheet, and provides additional functionality around date fields. We need to be able to easily restrict dates based on pre-set deadlines (i.e. report requests cannot be made for any date less than 12 business days in the future). Ideally we'd like…
-
Auto Assigning Values In Smartsheet
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I would like for the value of percent completed to auto-fill to 0 Whenever a new task is made, and leave it up to the employee…
-
Can you Index-Match referencing multiple sheets?
Hi! I am a newbie to Smartsheet and jumping in head first. I am trying to use Index-Match to bring in information to a master sheet, but I need the function to look at multiple reference sheets. Master Sheet Highlighted in pink are the columns I am referring to. I would like the User to manually input a number into the…
-
Cell referencing in a IF(CONTAINS(OR())) statement
Hello everyone , I am trying to use the @cell operator in my sheet , but I am cross referencing sheets and getting an invalid operator I am wondering if I am using incorrect syntax within my function , or braking the rules of the language . If someone could help me correct the formula that would be great !…
-
New Template Sets for these Workflow Categories! Let me know your thoughts!
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your organization work remotely more efficiently. Let me know your thoughts, but we are…
-
Timeline end date not updating correctly - help needed
Hi, I'm having an issue with my end date at the top not updating correctly. I have all the subtasks below indented correctly; however, it will not reflect that at the top most level. Please see the photo attached. I added in a new line at the bottom with an end date of 03/09; however, the date at the parent task refuses to…
-
INDEX MATCH Multiple criteria
Hello, I am trying to get the zip code based on city and state from a different sheet. The sheet that I want to return information from has 3 columns: City, State, Zip code. There are 20,000 rows in the sheet that I am trying to use as a reference with all the cities in the United States The sheet that I want to write the…
-
Child Cell Formatting
I would like for child cells to automatically appear for each new row, and then have an index/match formula be able to populate a column in the parent row from those child rows. For example: New air freight request- 5 child rows with default values of the 5 carriers pop up (can't do a dropdown, I need to track the 5…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?
