I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of e…
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I…
I have a project with dependencies and multiple assigners enabled. I would except that the tasks duration will be reduced by the number of ppl working on the project, but that's not the case. It seems…
Hi, Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formu…
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as d…
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it …
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date col…
I have a sheet where I am collecting specific account information, but then want to collect names and demographic for multiple people. Is there a way to only input the account information once, but th…
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range …
