-
Looking for help with nested IF and FIND
I'm looking to return text based on the content of a single, fixed cell, but I believe my syntax is bad. Column A, Row 1 could potentially be "Q3M1W1", "Q3M2W1" or "Q3M2W3" which would be entered manually by the user. I would like to have another cell display "M1W1" if A1 is "Q3M1W1" or "M2W1" if A1 is "Q3M2W1" or "No" if…
-
How to calculate weekly GP on a gant chart?
Hello All - I dont believe this is possible with smartsheet - but I want to make sure before I purchase a one off. I have included a screen shot below to illustrate my goal. This screenshot is from a colleague who uses FastTrack for this one and only purpose. I currently have a master schedule that shows all of our…
-
Sum of all descendants
Hi I am trying to add a formula to get the sum of all descendants. I have used =SUM(CHILDREN()) but that only adds in direct children. I need to also be able to add in the grandchildren, greatgrandchildren, etc. Any way to do this? thanks
-
How to configure a project assignment and the assignment date and show the rest of the fields diseab
I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are other ways of being able to assign people and date of assignment, automatically without…
-
Troubleshooting with IF AND formula for the automation of RYGG values
Hi Everyone, I am using a sheet too manage and track mails received by my department , and I am having troubles defining a formula to automatically display in a symbol type column ( called Statuts ) , a ball whose coulour depends on some circumstances . I would like to precise that I am using the French version of…
-
formula to turn red flag on at risk column on set no. of days before Completion Date
Hello. Please help w a formula to turn the red flag of the 'at risk' column for various number of days before the date set in the Completion Date column. Thank you. Dan
-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…
-
Count Month from Date Value field
Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for each row from JIRA and, since this is an automated extract feeding a live dashboard, creating another column to extract the…
-
Helper Column Parents and Tasks with 0 Children
I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I can tag in conditional formatting along with my Parent Rows that have children. Can you help me create a formula that can do…