-
Pulling Column Info Based on Column Containing Data in Separate Sheet
I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT…
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
IF(AND(NOT(ISBLANK Formula Trouble...
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula. If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have. =IF(AND(NOT(ISBLANK([Provisional Requested…
-
Modified Date(auto populated by system) get changed for all record without any modification in sheet
Hi Team, In my smartsheet, Modified date which is an auto populated/system generated column, gets changed automatically for ALL the records even though we are not doing any changes in any of the records. This is causing issue in our workflow. We have defined modified date as the trigger point of our workflow. As a result,…
-
How to create create an audit workbook for a team of 20
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Best way to carry out teams audit and monitor progress
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Automated import through the API
Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D models and part properties and that enables communication with the supplier. Object of…
-
Calculated parent % complete issue
Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the %…
-
What's with the "unnamed series" in the pie chart?
So I've created a pie chart in my Dashboard and let's say I have basic data such as: Apples 5 Oranges 12 Bananas 8 Blueberries 20 Strawberries 3 Rasberries 19 With this data, when I tried to import it as shown above, it gave me an error. When I imported only the values/numbers, it worked. However, now I cannot show which…
-
Does Smartsheet email support respond?
I have been using Smartsheets for about a year and don't seem to have much luck getting any response from Smartsheet support via email. Recently noted when they introduced multi select drop downs that the dropdown fields do not appear when you use the gmail add on. Reported this to Smartsheet via email seeking a solution…
