-
Tracking Employee Effort Across 170 Projects
I have a little experience using Smartsheet in my previous role at FSU and am now trying to help them adapt to some (unforeseen at the time) scaling and relational issues on the sheet/form I built. Specifically, this tool has been implemented as a way to track effort/time on a large 5 year federal contract. Our current…
-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
Percentage Complete of child tasks
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete of child groups in the parent row. Note that I am not using dependencies, and am using an independent "% complete" column (I…
-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Email content into a sheet
Box has a great feature where you can send an email to a specific box email account, and it will automatically put the attachments into the folder associated with it. It would be great if we could email a designated smartsheet email, and have it automatically add a line to a sheet with the attachment or content included.…
-
Countif and HAS for multiselect for Quiz answers
I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure why?
-
Can this excel formula be created in smartsheet?
=IFS(A5>B5+C5,"RED",B5>A5+C5,"Green",C5>B5+A5,"Yellow") If anyone can help me I<d be very appreciative :)
-
Unable to create cross-sheet references
The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" . How many references we can do? I am using a sheet that has information of 13 sheets combine. (like a summary sheet). I like the summary sheet but the information…
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…