-
Can I have 2 users fill out the same form?
Hello, Is it possible to have user #1 fill out the required fields of a form and submit it, and then have user #2 view the same form with the answers submitted by user #1, and fill in any optional fields? I am looking to streamline a process so that it creates one entry in my sheet, rather than have each user fill out the…
-
Row ID or Link
Hello I've seen people post about this, but I haven't found a way to use it or if there has even been an enhancement added to Smartsheet. I'd like to be able to use a formula to insert the Row Link to a cell, which I can then access via INDEX/MATCH on another sheet. I have a list of projects that were completed by fiscal…
-
Locking some users from editing a form
Is it possible to prevent someone from editing a form after they fill it out? I want certain users to not be able to change their form responses after submission. Thank you, Maya
-
Calculating Monthly Revenue
I would like to sum monthly revenue estimates of projects on our schedule sheets. We have several projects that straddle different months, this IS where it gets tricky. Is it possible to build a formula that looks at a project and if the Start/End date straddles a month, it then calculates how many working days in each…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
Way to automate check boxes in a form?
Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
Sending Rows Monthly to Individuals w/o Underlying Sheet Access
Hey y'all - I'm looking to set up a sustainable option, probably a workflow, to send row items to an individual for all entries they submitted in the past 30 days, without giving underlying access to the sheet. The specific use case here is this is a team wide hour reporting sheet, and we want to give folks visibility into…
-
Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell: I am using the COLLECT function to show the contents of a…
