AverageUser✭✭

Comments

  • Kevin, I believe it is the $ that is causing your issue. I was working on a similar issue and found a list of things that aren't compatible with the new "Column Formula" feature. One of those items was "Absolute References". The error message that you're getting probably has a link to the following url, which is where I…
    inColumn Formula with VLOOKUP using External Reference Comment byAverageUser 10/28/20
  • That might be a possible solution. I watched the video at: I'll contact[email protected]and get a quote.
    inMaster Dropdown List (aka using same dropdown on multiple sheets) Comment byAverageUser 06/09/20
  • Chiming in that this is indeed a BIG PROBLEM! Try as I might, I can't understand the reasoning for making this a global change and how this made it through your approval process. Very poor decision. I give a lot of praise to Smartsheet when you do something right... this is totally wrong.
    inUpcoming changes to our automated notifications - live today 17th April 2020 Comment byAverageUser 05/14/20
  • 我同意bhope51. This recent change was just asinine to begin with. As far as I know, this change was not communicated... or at least not well communicated. Why would you want an automated response to something completely general associated to a single person just because they were the one who set up the…
    inDisappointed in Automation Announcement Comment byAverageUser 05/13/20
  • I can't tell you how excited I am to have stumbled across this information today!! I also put this in as an enhancement request several months ago. I am very much looking forward to trying out the new feature as soon as it is available.
    inDynamic Forms Comment byAverageUser 04/29/20
  • I'm actually considering Barry Bowles solution in the Youtube video above, but I'm concerned about any potential security risks associated with allowing their API to access my sheets. Is this a valid concern?
    inPopulating a Dropdown List Comment byAverageUser 02/07/20
  • You can just toss the analysis for the year on the front of the series of "IF" statements like: =IF(YEAR([Refresh Year]1) > YEAR(TODAY()), "Red", IF([Wants refresh?]1 = "Yes", "Green", IF([Wants refresh?]1 = "No", "Gray"))) Be sure to change the "[Refresh Year]" variable to whatever you named your column.
    inChange RYBG Color if the year is Greater than the current year Comment byAverageUser 10/07/19
  • Can't help on the "12:00" part since I can't even figure out how to get "Time" formats...? But for the "Holidays" question, you can use =NETWORKDAY([Start Date],[End Date],[set an external cell reference to a column in another sheet with your holidays listed as dates]) It will exclude any of the dates included on the…
    inCalculating Time Comment byAverageUser 07/16/19
  • Well... you just had to go and make a super elegant solution that makes mine obsolete lol. I love this approach and had never used the COLLECT function. Definitely going to familiarize myself with it now. However, it would still produce an error if ALL of the referenced date fields in a row had text values (but I bet that…
    inText in Date Column Messing Up Formula Comment byAverageUser 06/21/19
  • When you are checking the columns that may or may not be a date value, use an IF() to set the value to a date in the formula if it is not a date. "=IF(AND(IF(ISDATE([DateColumn]1), [DateColumn]1, TODAY()) < TODAY()), 1)" So if the value is a Date, it will evaluate the date... but if it is anything other than a date, it…
    inText in Date Column Messing Up Formula Comment byAverageUser 06/20/19
Avatar