Best Of
Re: SUMIFS with two condition in the same column
Hi @Eyglo
It looks like your column references are off a little - you'll need to wrap [square brackets] around the column name each time, instead of around the column name listed twice.
=SUMIFS([Estimated DC kW]:[Estimated DC kW], [Stage #]:[Stage #], OR(@cell = "0. Pipeline", @cell = "1. Backlog"))
Additionally I noticed your quotes are curved. Ensure they're straight up and down "" like so!
Cheers,
Genevieve
Genevieve P.
Re: New and improved Safe Sharing experience, now generally available!
@Zac Wolfram - Do you have Data Mesh or Bridge? I haven't had a chance to try it for this purpose but I am thinking in the same vein: Once a domain or external email is approved, add the domain or email address to a new row (and just add value to the one column, instead of using a Copy Row automation). Data Mesh would have to run from a report, and would be limited to hourly. Bridge could trigger immediately. @Lekshmi Unnithan - Curious if there are any restrictions to using these tools to write data to the approved emails or approved domains sheets?
Scott Peters
Re: "submit and open new form" option
Hi @drkailey
You can set a form to allow a new entry as soon as the submission has gone through from the Settings tab:
If you're looking for the form to remember a previous entry, there's another Idea already created around this topic! Please add your vote and voice to this thread: User-selectable "Sticky" Form Response Fields
Cheers,
Genevieve
Genevieve P.
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