-
one task through multiple calendars
I'll try to explain what I'd like to accomplish. My task name has sub-tasks for example "custom","boxcut", "assemble","finish" that populate calendars. On the calendars they show all of the "custom tasks" for all main jobs. How would I setup a calendar to show all the sub-tasks for just the selected task. Such as the…
-
RYG symbols and nest IF's
I'm new to the community and frankly new to Smartsheets... I'm building some RYG indictors to give a quick visual indicator when a task is at "risk".. my nest IF statement is set to track a task against TODAY() - Finish... ie the closer the Finish date comes to Today's date, the higher the risk. My challenge is the Green…
-
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
-
Card Format - Report
I have built a report combining all my individual sheets to keep of ongoing tasks in one place. I want to be able to view this in Card View, but that doesn't appear as an option in the Toolbar. Is there something I can do?
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Minus workdays from dates
Hello, I'm trying to minus days from dates using the following formulas but am getting errors everytime: =NETWORKDAY([Date Printed]8 - [Date Dispatched]8) - gives me the error #Incorrect Argument Set =NETWORKDAY([Date Printed]8, [Date Dispatched]8) - gives me #Invalid Data Type What i'm trying to do is find out how many…
-
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…
-
Color Changes and Filter Bar?
Perhaps I'm loco, but 02/13/18 during the morning hours, I did not notice anything unusual about my landing screen colors. I log on after I get home, and my open tabs are now Orange and blend in too well with the background, and I now notice a Filter bar. Was this an update? I don't like it. Can we please get another…
-
VLOOKUP #INVALID DATA TYPE
I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true) [Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS}…
-
Formula is changing after a date sort
Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171) Thus not including any data from rows 4 thru 15. I have locked the row with the formulas…