-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))
-
Is there a way to RECONNECT a form field to a column in the sheet? Feature Request?
So here's the scenario: You build a form and it creates the sheet automatically. Then, for some reason, you accidentally delete a column in the sheet. The form field still exists, but the column is gone. You recreate that column exactly like it was in the sheet, however, now the two are no longer connected. It'd be great…
-
Copy data from secondary sheets to primary sheet
We are setting up a project approval process. We have a primary “Intake” sheet where initial project data is entered. In many cases, users will be providing project budget and resource information later. We do not want them entering data directly on the sheet so would like to use supplemental forms using a project ID as…
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Is it possible to share a sheet with only certain people in the workspace?
I would like to share a sheet but not with all the users that are in the workspace. Is it possible? Also, I would like to give access to that sheet to other people not in the workspace. Is it possible? Thank you
-
STOCK FOLLOW-UP
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…
-
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…
