Best Of
Re: Collect a Value from a Column if Today's Date Falls Between Two Dates
That was it. Thank you, Isis. Just when I think I am progressing to intermediate knowledge of Smartsheet, I am humbled to know that there is so much more I don't know!
GMichal
Re: Creating a dropdown list from values in a column on another sheet
All of these posts are from 2 years ago asking this question??? Why isn't this a basic feature yet?
Meszarj
Re: Licenses and True-up confusion
Am I understanding that we no longer have what used to be "Users" and they have to have what is the equivalent to a license??!!!
In one sheet, alone, we have 129 who have been shared to the sheet with only five of us being licensed users.
Automatically charging is quite concerning, as well. Will there be a notice sent to the SysAdmin well ahead of time to make any needed updates?
Regarding this process, this isn't a feasible work-around…this would take more man power to send out the update requests: "If they're making minimal changes, you could provide them with Viewer access to the sheet and then send them Update Requests to have their input without needing to make them a Member."
This will utterly destroy our use of Smartsheet as we have so many current users that contribute daily to the various sheets/reports.
Ask anyone I work with and they will tell you I have been a huge proponent of Smartsheet - even rejecting the possible use of AirTable. If all the above is true, I will have no choice but to being looking elsewhere…
I would appreciate a phone call from our Smartsheet Representative to talk about this.
Loann McGee
Re: Licenses and True-up confusion
There also needs to be a way to lock a user to an access level - otherwise, we'll have to spend time each quarter carrying out this stupid true-up process.
There's no API for this, so we can't even automate the process.
rscott
Re: March Question of the Month - Join the conversation and receive a badge
One big skill I've been working on is self-gratitude. We're often too hard on ourselves, and it's very easy to have thought patterns that lean towards negative language. Re-training my brain to use positive language and affirmative statements has been tougher than I thought but so important!
Monique Odom Stearn
Re: Formula not picking up reference data - ANSWERED MY OWN QUESTION
Thanks for the tip! Much appreciated!
BettyJo
Re: Trouble with IF statement and date format conversion
It is because 12 + 1 is 13, and there is no 13th month.
Try this instead:
=IF(LEN([Delayed Result Date]@row) = 10, DATE(VALUE(RIGHT([Delayed Result Date]@row, 4)), VALUE(LEFT([Delayed Result Date]@row, 2)), VALUE(MID([Delayed Result Date]@row, 4, 2))), IF(LEN([Delayed Result Date]@row) = 7, DATE(VALUE(RIGHT([Delayed Result Date]@row, 4)) + IF(LEFT([Delayed Result Date]@row, 2) = "12", 1, 0), VALUE(LEFT([Delayed Result Date]@row, 2)) + IF(LEFT([Delayed Result Date]@row, 2) = "12", -11, 1), 1) - 1))
Paul Newcome
Re: Parent/Child Formula for Levels
@PeggyLang Yes. Task@row should be referencing a column that will always have data in it. You can insert a hidden auto-number column if needed to do this.
Paul Newcome
