Best Of
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
Re: Login Issue to Smartsheet
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Automated workflow Outlook email with attachments based on form responses
Hi all :)
I am trying to figure out how to create an automated workflow that will email the respondent PDF forms based on their answers. To put it into context, we will be having new providers "registering" themselves using a form where I would like to have them select which programs/software they need access to. In order for them to get access, they need to fill out program/software agreement forms (like access to a client records database). I am hoping to create a workflow that sends them a copy of the specific forms they need to sign, based on which programs they need access to.
Something like:
"[Insert Name]
Thank you for registering with our program! You indicated that you need access to Asana and Miro. Please sign the attached forms and --- back to us, so we can get you started."
Ideally, if they can reupload them to SmartSheet or have some way to send them back signed to us, it will then be forwarded to the appropriate admins of the programs/software.
Is this possible?
DHRElle