-
Stacked bar chart that only goes to 100%
Hi, I'm trying to create a stacked bar chart that combines the Actual number, the Deal Model Number, and the projected number into one line. I'd like the bar chart to only go to 100% and as the Actual number goes higher, it shows it creeping up the bar towards the deal model / projected number. I'm not even sure what kind…
-
Trying to get RYGB to work with two columns
If the PO Process Status is "8 - PO issued" use Blue Harvey Ball. Formula that works: =IF([PO Process Status]@row = "8 - PO issued", "Blue") If the Pending as of date is less than x etc. use Harvey Ball... Formula that works: =IF(TODAY(-4) > [Pending As Of]@row, "Red", IF(TODAY(-2) > [Pending As Of]@row, "Yellow",…
-
Workflows failures
We have multiple workflows that appear to be overriding each other. An approver is getting 2 approval requests for requests that do not touch his workflows. Another approver is getting 3 approval requests for request that do not touch his workflows. I've gone though the approval requests, removed one of their names and…
-
INDEX/MATCH with a HAS Function for Multi-Select Column
I am trying to create an INDEX/MATCH where the INDEX is a Checkbox column and the MATCH is a multi-select column. I am not sure how to incorporate the HAS function for the multi-select column. I would like the High Priority flag marked if any/1 or more of the Sites Under Consideration are flagged a High Priority in the…
-
Looking for a simple web-based relational database system.
Hello all, we have just launched a startup. Now, we are looking for a simple web-based relational database system where we can easily add tables and connect them to one another through foreign keys. For example would we want to create a suppliers database in which we could perform a query such as "show me 1. all suppliers…
-
Combine 2 sheets into one
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it…
-
Override for Formula Column
I have a formula column that is updating a status based on an end date column. I have to keep it a formula column because the information in the sheet will be coming from form entries so I want to ensure that every new row has the status determined by the formula. That said, I need to create an override to manually apply…
-
Formula ISNOTBLANK with multiple cells
Hi I'm trying to write a formula that says if cell A is not blank and cell B is not blank but cell C is blank say false but I am getting an error. Help? =IF(ISNOTBLANK([Total number of cases (100) of 10 kits]@row),(ISNOTBLANK([Shipped Date]@row),ISBLANK([Received Date]@row)=false)
-
Adding Condition to IF Statement
Hello! I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID…
-
Is there a way to have a formula for the whole column?
Hi Smartsheet, I am utilizing Smartsheet for employee information and have found a way to generate documents. I want to be able to title the document "Effective Date - Employee Name - Change Reason." I've looked up resources since the title of generating documents can only hold one column. Other Smartsheet resources told…
