Best Of
Re: File Library: Single File Sharing Now Available!
This is a great new feature since sharing access to the workspace kept us from a few ideas we have had. This lets us revisit those solutions!
Matt Rasmussen
Re: TRYING TO FIND THE ERROR IN THIS FORMULA
You can do a lot of troubleshooting by checking your parenthesis - if you doubleclick into the cell and then use the arrow keys to move back and forth over a ")" it will highlight the corresponding "(".
Looking at your formula, you've got the following issues:
- you have no end to your iferror() function - the format for this function is " iferror(try this, if you get an error do this)" - you don't have anything filled in for what to do if you get an error. Your very last parenthesis should have a comma right before it and something to do in the event of an error, like this (not yet fixed in total):
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN")))), "Error encountered")
2. Next, you've got 3 nested If() statements but your last one doesn't have any instructions on what to do if it is false. If statements are constructed "if(test, instructions if true, instructions if false)" and you've got nothing after "Green" for what to do if false.
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN", "None of them")))), "Error encountered")
3. Similarly, your very first If statement doesn't have a false condition noted either:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN", "None of Them"))),"Date Blank"),"Error Encountered")
4. Finally, you've got an extra space in your green logical test that is breaking your today() function (and was the cause of the unparseable error you were likely getting:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY() + 6, "GREEN", "None of Them"))),"Date Blank"),"Error Encountered")
Now it should work for you :)
Jgorsich
Re: TRYING TO FIND THE ERROR IN THIS FORMULA
Hello @Marce Romo
You're missing a value if error.
Your formula should look like this:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN")))), "value if error")
Melissa Yamada
Re: Pull latest amount from a column based on date column
@Isis Taylor That worked, thank you so much!
alys
Re: Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator
hi @MTorres224,
it would be easier to provide the link to the post so it would be easier to find it and read the content of what Nino discussed with Andree.
It was never possible to be Admin on any sheet without license… the higher was Editor tha can share.
So even with the new User Subscription Model does not change anything for Admins as if anyone needs to change workflow, add new column etc. needs to be Admin or Owner and both of those need paid license.
hope it helps.
kowal
Re: March Question of the Month - Join the conversation and receive a badge
I'd like to learn to weave. I know the tutor and course I want to go on just need to find the time.
Workwise I'd like to learn to say NO and not immediately jump in and volunteer then wonder why I am overloaded :)
SueinSpain
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