-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Alert a user when an automation isn't going to work
I have a sheet where there is potential for an incorrect email to be added via a form (SS requires an email be entered for it to populate correctly into a contact column if not in the SS directory-if you have a fix for this, I would love it!). As the owner, I am notified when a user will not be alerted due to an incorrect…
-
Smartsheet "Viewership" Access being denied!
Is anyone else experiencing a Smartsheet wide, all Workspace issue where unless your viewership is "Admin or Owner" you are unable to access sheets that you supposedly have access to? I've noticed the glitch "Fix" itself if I change someone's permissions from Viewer or editor to Admin, then put it back to their original…
-
Templates and conditional formatting
I have created a Project Schedule Template that has all my conditional formatting included. However, when I import in a schedule from Microsoft Project the conditional formatting not longer exist? Obviously, I am doing something wrong? If you can lend any advice, it would be appreciated. Best Regards,
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Ability to Adjust Axis Maximum
Hello, I'm opening a new discussion since the old version hasn't been responded to in some time. Stacked graphs are for some reason adding cushion on the ends. Is there no way to top these out at a certain number or percentage? In my case, I'd like to stop the percentage at 100%. Can we at least know if this is a priority,…
-
nested ifs with greater than less than- #unparseable
Wrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Yellow", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), "Green", "")))
-
Reminder Escalation
Hello there! I set a reminder in the grid view to inform the project owners of the 4 teams that they know before the start date, if they don't change the status to "Complete", they will be reminded every 3 days, if they change, it will no longer Remind. Now, I want to set up an upgrade reminder based on the previous…
-
Subtracting dates
I have an excel sheet that subtracts dates. The formula is as follows: =IF(P4="","",NETWORKDAYS(P4,Q4)-SIGN(NETWORKDAYS(P4,Q4))) This formula works. When I use it in Smartsheets, the formula is as follows. =IF([POC Date (Planned)]3="","",NETWORKDAYS([POC Date (Planned)]3,[Actual/Pending Date]3-SIGN(NETWORKDAYS([POC Date…