Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Automate RYG (percentages)
Hi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green. I have used this formula, but is not working, any other thoughts around this? =IF([%…
count decision formula
Hi all I have a sheet that using the decision symbols, can anyone help me with the formula that counts the number of Yes, No, Hold. I would be happy if there was a way of just counting the number of the green yes Many thanks
Forms customization
The required field indicator is a red asterisk. When we built a form, we mentioned that anything with a red asterisk is required - but we can't customize any of the text (including the asterisk) in the description. So the referred asterisk is black while indicating it's red. Perhaps it's minutiae, and the details sometimes…
Does Smartsheet keep previous versions of spreadsheets?
I am wondering if smartsheet keeps previous versions of spreadsheets on the off chance of the sheet being completely deleted?
Email alert when not modified
Hi All i have created a card view that are work packages for staff, i am requiring them to update the cards every 7/14 days with status and commentary. is their a way to build an alert that sends an email to either myself and/or the assigned staff member that lets them know the card has not been updated, additionally in…
Scheduling on non-working days and holidays
I have labor day in my non-working days' list. Smartsheet is still scheduling jobs on that day. I am running by predecessors. What is going on here?
Smartsheet Error: formName: ajax fa_loadContainer serverStatus: false serverStatusText: CriticalExce
What is the cause of this error? How can we prevent this from happening again? Is there anyone experiencing the same error? formName: ajax formAction: fa_loadContainer serverStatus: false serverStatusText: CriticalException errorCode: 6
Angular JS
Does anyone know if you can use the smartsheet api for nodeJS with Angular?
SUMIF Between Sheets
Can smart sheets handle a sumif across different sheets? I want to do something like this.... In sheet B: SUMIF (range in sheet A, where the task is the same as task in sheet A, add all the hours in sheet A) - should return total hours where tasks are the same. This is difficult to describe - please advise! :)
Color Pallet
Is it possible to have a wider range of colors to choose from within the color pallet? When making gantt charts it seems I am limited a bit too much.