-
Data Entry With a Filter
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The sheet is long so I create a filter to pull up a specific vendor. In the first blank row under that vendor I type in the…
-
Countifs with with percentages
What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated! =COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In…
-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Using <=/>= in an Alert
Hi - I am trying to set up an Alert for when a column gets to greater than or equal to .75. When specifying a change, I can only select existing values. When I have typed ">= .75" I have not gotten any updates when that change is met. It makes me believe that typing in "<=" is not valid. I have looked through the community…
-
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…
-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
Count if dates are within the next 7 days
Hello, I'm trying to use the COUNTIFS function to search a reference column full of dates to count how many are within the next 7 days. For the criteria portion of the formula, I've tried using, "<TODAY(7)", "<TODAY() + 7", but they are not providing me with the correct (if any) result. I would like to avoid having to…
-
Government Utility Projects and Asset Records
Hello Smartsheet Community, I work for the City of Minneapolis, in Minnesota, and I’m looking to reach out to see who is working for governments (local, county, state, or federal) while incorporating Smartsheet into their utility project management processes. Smartsheet is restricted from its privacy policy to release any…
