Best Of
Re: Comparing dates
Hi,
assuming your columns are formatted as dates, the below formula would work
=MIN(COLLECT([Date1]@row:[Date3]@row, [Date1]@row:[Date3]@row, >=TODAY()))
Etienne F.
Re: Created Date Issue
Hi @George Lie
System Date columns store date stamps as UTC, or GMT (although it can display the value in your local time).
This means that a formula looking at that cell will bring through the date value based on GMT, which is likely why you're seeing inconsistencies.
However, the Record Date Automation is based on local time! You could select a change in the Created column as your trigger, which only happens when the row is created. I would suggest using this workflow to populate a different date column, then reference this in your Start date column... or use it instead-of your Start date column? See: Set the Current Date with Record a Date Action
Cheers,
Genevieve
Genevieve P.
Re: Can I share the Workapps to collaborators and grant him the access as admin level?
To add group members in bulk you can copy and paste up to 1,000 email addresses from an Excel or .csv file into the "Add Members" tab. Here's more information:
Genevieve P.
Re: IF Formula Unparseable
As an extra credit followup to the above...
It looks like you are going to be creating a series of IF functions to display the month name from the Date in your date column. That is a great approach but there is a little trick you can do if you only want the 3-character month name. This will save you from having to nest IF functions.
This formula here...
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (MONTH(Date@row) * 3) - 2, 3)
takes the text string JanFebMarAprMayJunJulAugSepOctNovDec
And extracts a middle part of it using a little math based on the month number
This part here defines the start position within the chunk of text to extract:
(MONTH(Date@row) * 3) - 2
It says take the month number from the date and multiply it by 3, then subtract 2.
- So January is (1x3)-2 = 1
- February is (2x3)-2 = 4
- March is (3x3)-2 = 7
And if you look at the text string "Jan" starts at position 1, "Feb" starts at position 4, "Mar" starts at position 7...
The
,3
at the end of the function says to extract 2 characters.
- So for a date in January, it starts at position 1 and extracts 3 characters - Jan
- For a date in February, it starts at position 4 and extracts 3 characters - Feb
- For a date in March, it starts at position 7 and extracts 3 characters - Mar
I know you didn't ask about this, but thought it was a cool and helpful tip.
KPH
Cool Features of smartsheet to be aware of
Hi Team,
Lets share and discuss in this group about some of the super cool features of smartsheet which help us in the daily work also:
To begin with - i aware of some good number of features and offering below one for the day and we can begin collaborating on this more to learn
---------------------------------------------------------
Cool feature for the day:
Grid View: This is the primary view in Smartsheet, resembling a spreadsheet. It allows users to organize data in rows and columns, similar to Excel, and includes features such as sorting, filtering, and conditional formatting.
Humashankar
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid, I wanted to be the first woman President of the United States. I wrote an essay about this in the 6th grade. For some reason, I believed I needed to become a lawyer as the first step toward this huge goal (although - and I am dating myself here - Ronald Reagan was the president at the time, and he was an actor, so ... 🤷🏻♀️) My teacher happened to be married to a lawyer, and she would take me after school once a week to his office to observe. He, in turn, took me to court with him a few times. That path led me to law school. To my great relief, there wasn't a math section on the LSAT, and one of my favorite jokes was that I went to law school to because there was no math. (Although, that wasn't entirely true ...) I practiced for about 13 years before my dissatisfaction and disillusionment (such a long story) lead me to a second career in business strategy and operations. And, whoooo boy, is there math aplenty. But, that yielded one of the greatest revelation of my life - I am, in fact, not bad at math at all. I often wonder what path I would have followed had I "math" mentor the way my sixth grade teacher and her spouse mentored and nurtured my presidential ambitions (of which I now have negative-infinity-squared. 😆)
Danielle Arteaga
Re: @Mentions in Dynamic Views in WorkApps
Hi @MHalvey
Firstly, thank you for posting about your process and experience! This content would be helpful for the Product team to hear as well - when you have a minute, please add your vote and comments to these Product Ideas:
- @ people within WorkApps commenting
- Dynamic View Comments notifications for user without access to source sheet
To eliminate the sheet name in an email notification, you would need to use sheet workflows (versus @mention emails) and use the Message Only option. You could surface the comment in a Latest Comment column (see: Add a latest comment column) then surface that content in the message (Customize the content of your alerts and requests)
Cheers,
Genevieve
Genevieve P.
Re: Total from Another Sheet
Hey @AlexysR -
Gotcha there is two ways you can do this, either you pull the totals into their columns and then add them together on the sheet in a 3rd column using =cell1+cell2 or you can combine them like so =SUMIFS(formula 1) + SUMIFS(formula2).
In terms of the formula you used above, you are very close, just need to remove the 2nd "=" like this: =SUMIF({US Payment request Range 1}, [PO Number]@row, {US Payment request Range 2})
Does that help?
Antonie B