Skip to content
  • Try Smartsheet

    • Best Of

    Re: Month to Start automation

    @Paul.Woodward It looks like your solution incorporates things from Excel that do not work in Smartsheet. You may want to double check your source(s).

    @TEATom This will be the formula that will check a box for any assignments the have a [Month To Start] in the current month:

    =IF((FIND([Month To Start]@row, "JanFebMarAprMayJunJulAugSepOctNovDec") + 2) / 3 = MONTH(TODAY()), 1)

    You would then set up your alert to be triggered on a recurring basis (select a date based trigger and then select "Custom" instead of "Run Once" and have a condition of the box being checked.

    ·

    Re: How can I exclude notifications to myself when I make the changes?

    Hi @tlechi , great point!

    You're right that the formula works best when it's just one contact, but here's something that might help even when multiple people are commenting.

    Since the Latest Comment column always reflects only the most recent comment — including who made it and when — the logic still holds up. Even if multiple people comment around the same time, Smartsheet processes them one at a time in the order the server receives them. So the Latest Comment will always represent the valid "last" comment, and the check to see if it's you will continue to work reliably.

    image.png

    Also worth noting: adding a comment doesn't even require saving the sheet, so the update to the Latest Comment field happens independently of other edits — meaning this method remains consistent even when multiple users are working on the same row.

    There may be edge cases, but in most typical scenarios, this method seems to work quite well.

    ·

    Re: 'Save' cross-sheet references (reached limit)

    @PeggyLang When I run into this, I will join multiple cells together with a formula, INDEX/MATCH that over to my target sheet, and then parse it out there. Basically what you are wanting to do but with a couple of extra steps in the middle. I have found that parsing is easier when I use UNICHAR delimiters in a specific order. Something along the lines of

    =UNICHAR(8601) + [First Column]@row + UNICHAR(8602) + [Second Column]@row + UNICHAR(8603) + [Third Column]@row + UNICHAR(8604)

    Notice my delimiters are UNICHAR functions for 8601, 8602, 8603, and 8604. This makes managing the parsing that much easier.

    Now you can use an INDEX/MATCH to bring over this helper column that has the delimited string in it and use this to grab the first.

    =MID([String Column]@row, FIND(UNICHAR(8601), [String Column]@row) + 1, FIND(UNICHAR(8602), [String Column]@row) - (FIND(UNICHAR(8601), [String Column]@row) + 1))

    To pull the second piece from the string, change the UNICHAR functions from 1, 2, 1 to 2, 3, 2. The third piece from the string would be 3, 4, 3. The basic idea is that the first UNICHAR is the "piece number" you want to pull. This coincides with the fact that it is in the "character to start with" portion of the MID function. Then to tell the MID function how many characters to pull, we subtract the start of the first piece from the start of the second piece.

    So boiled down it would look like this:

    =MID([String Column]@row, start of first, start of second - start of first)

    And using those specific UNICHAR functions to start, delimit, and end the string makes it much easier to just copy/paste/tweak to get the next piece from the string.

    ·

    Re: How Can I Automatically Remove Outdated Rows for Updated Project Data?

    Hello @Khadija Ali you can create a helper column (for example a checkbox) as an identifier of which to be removed then you can create an automation moving the rows where the helper column is checked move to an archive sheet.

    ·

    Autoplay videos embedded on dashboard

    Good morning,

    I have a 15 minute timer video from YouTube on my dashboard that I would like to play automatically when the dashboard is loaded up. Is this possible?

    ·

    Re: I am trying to average ratings by category.

    Try something like this:

    =AVG(COLLECT({Range To Average}, {Category}, CONTAINS("Brand", @cell)))

    Make sure to leave the @cell exactly as it is. You should only need to update the {Cross Sheet References}.

    ·

    Re: Can a filter be applied to an already filtered list?

    You would need to insert a helper column with a formula that combines both titles into a single field. This column can be hidden after setting it up to keep from cluttering things but still accessible in the filter.

    =[title1]@row + [title2]@row

    ·

    Re: JOIN formula to ignore cells in blank

    Hi Jean,

    You’d need to use a JOIN COLLECT combination instead.

    Something like this.

    =JOIN(COLLECT(Reedev@row:Yisan@row, Reedev@row:Yisan@row, <>""), "| ")

    Did that work?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    ·

    Re: Proofs - Evaluation Mode Watermark

    Hi @meghan.hale66546 & @PDunn

    We have received a number of other reports seeing the same thing. The team is aware and actively investigating!

    ·