-
Auto populate multiple checkboxes from 2 dates
Hello! I am trying to auto populate multiple checkboxes from the anticipated start date and end date based on the fiscal years. For example the 10/5/21 to 4/30/22 would have Q2, Q3, and Q4 check marked. Is there some formula that would allow me to be able to automatically checkmark every quarter that is between those 2β¦
-
Creating SUMs based of a multi-select column for each selection.
I have a report that has a multi-select column with a variety of selections. I am trying to create cells at the bottom of that report that show the total #/SUM of each selection that are within that multi-select column. (Ex. I have a sheet that has column with you can select Active, Pending, Completed from a drop down. Iβ¦
-
SUMIFS Formula to calculate the sum between dates
Hey Smartsheet Community, I have a rather simple formula that is giving me trouble, I am just trying to get the sum of a revenue column between two dates. So far this is what I have and it is coming back unparseable: =SUMIFS({start date}, >[Start Date]@row AND({end date} < [End Date]@row), {revenue}) Any help here would beβ¦
-
Embed Salesforce Dashboard in Smartsheet
Anyone know why my Salesforce Dashboard won't embed into Smartsheet? We have the Enterprise license for Smartsheet but when I try to put in the Salesforce Dashboard link into a Web Content widget, it still tells me that it's invalid. Thanks!
-
Formula that will display the lowest value from two data sets (with the highest value).
Hello Smartsheet community, I need some help fixing a formula. The goal = Display the lowest value between (the highest value between 1A and 1B) and (the highest value between 2A and 2B). The formula I created is: =MIN(COLLECT(MAX(COLLECT([DATE 1A]@row, [DATE 1A]@row, @cell <> ""), COLLECT([DATE 1B]@row, [DATE 1B]@row,β¦
-
2 cells with dates -blank reporting
Hi, I have a cell "signoff" with date a that is manually entered and cell "required date" which is autogenerated from a look up. In 3rd cell "timeframe met", I'm trying to report if "signoff" cell is <= "required date" then report Yes, if not report No -but if "signoff" cell is blank it currently reports back "yes" so needβ¦
-
Is there a function or formula to correct 1.1 hierarchy columns from being number and string values?
In this column I have highlighted the problem area. The smart sheet makes this into a decimal when there is one period, and makes removed the zero, breaking my hierarchy. I used this function in a helper column = Item@row + "" to make it into a string, but I'm left with the highlighted hierarchy as 1.1 instead of theβ¦
-
Issue with dragging a vlookup to the right
I have a sheet with a table of vlookups, 3 rows deep and 15 columns wide. One date per row, and the columns have "standards " - gold silver or bronze. I have vlookups to return values in another table on the same page, and these all work. However, I need to replicate this in 24 other sheets....and seeing as I am unable toβ¦
-
Using COUNTIFS
Hi All, Newbie posting. Been using smartsheet for my projects and keen to delve more into the reporting side for Board information. I have a Smartsheet that I use to record installs of certain types of products, we have three different types. I have used a formula to count the number of each type of product with an exampleβ¦
-
COUNTIFS using Or
Hi all, Please can someone help me with the below formula? =COUNTIFS({POD Number}, "POD 1", {Policy Category}, "Plan Value", {Service}, OR(@cell = "No Service", @cell = "Advisory, @cell = "Legacy")) I am trying to get the count of POD Number being POD 1, Policy Category being Plan Value and Service being EITHER No Service,β¦