-
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
-
Auto Sequence by Date?
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the…
-
Using CountIFs with cross reference and multiple criteria
Hello! I am looking for some assistance on a formula. I have a Master Sheet and a Helper Sheet. I am trying to calculate the number of specific events associated with a person within a date range utilizing cross-sheet reference. I have tried multiple formulas, but not having any luck =COUNTIFS({Sample Master Type}, "New…
-
INDEX/COLLECT with Partial Text Match
Hi - I'm trying to use an Index/Collect formula to bring back information based upon two text variables that could be included in my search range. Below is the formula as I have written it and I get and Invalid Column Value error when it runs. The columns that I am pulling information from are restricted dropdown columns…
-
Sumifs w/ cross sheet references not working
Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific customer is working. =SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row)) But when try to…
-
I need to calculate % Complete
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…
-
If(OR and Value formula issues
I have a check box that if checked I want my cell to be 0, but if it is not checked I would like it to sum up three other cells. What is wrong with my formula (Example #1)? I am also having an issue with values. If I have a formula that I am asking to return a "0" or "100" based on criteria (Example #2), I have to add…
-
CountIf formula issue with similar multi-dropdown items in cells
I am trying to count how many items in a multi-select drop down column fit the criteria to accurately return the number. My main issues are that the multi select columns have multiple criteria that need to be counted and that I have location names that area similar. Ex: TL1-6, TL1-60, TL1-61, ....TL1-69 I have tried:…
-
If then formula
How do I set up a formula so that if([column A]@row="something", copy the value in [Column B]@row to [Column C]@row,""). I appreciate any help you can offer.
