-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
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?
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)
-
ISBLANK Nesting
Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE 1 and TODAY in DAYS NO - the NETDAYS between DATE 1 and DATE 2 in DAYS So I thought it…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…
-
No longer receiving reminders/notifications
I have not received reminder emails or notifications in the app for any reminders/alerts since 5/22/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Formulas
Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…