-
Formula to pull data from one sheet into a different sheet.
Hello Smartsheets, I am building a sheet that will track an employees attendance of our monthly trainings. Sheet #1 is the raw data, Sheet #2 contains all of the formulas and combines all raw data in a legible way. See photos below. Sheet #1 This sheet contains all raw data received from the attendees of each monthly…
-
Concern with sum formula
Hello , Can you help me find out a formula in the " Cumulative Amount to Date " column , whose the result is the sum of data of another column from the first row to the row with the same number ? Thanks in advance .
-
Countif with column and cell reference instead using "XXX" name
Hi, i am building a large list of client that i going to use to create Dashboard with counting items per each client. My question is (maybe it is very basic), is there a way that in the formula Countif i can refer to the cell and column instead or using the "XXXX" name in the formula? here the formula that i am using and…
-
error Unparseable in formual
i have this formula and want to add one more critiria at the beginning. this one works good. IF([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", ""), IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job", ""), ""), "")) Tried this by itself and…
-
COUNTIFS and with 2 different values in same column with a value in another column?
I have two different columns lets say "Colone" and "Coltwo". Colone has a value GZ22 and GZ21. Coltwo column has two activities "Completed" and "Just Completed" I'm trying to create a formula to count which counts the activity "Completed " that are done in GZ22 with the activity "Just Completed" that are done in GZ22. and…
-
Simple task health formula issue
I am using this formula that I adapted to my comun names from one that was posted here elsewhere. =IF(AND(Start@row > TODAY(), [% Complete]@row = 0), "Blue", IF(AND(Start@row < TODAY(ROUND(Duration@row / 2)), [% Complete]@row >= 0.5), "Green", IF(AND(Start@row > TODAY(Duration@row * 0.5), [% Complete]@row < 0.5), "Yellow",…
-
Team Vacation Planner - automation to notify if too many people are taking the same day off
Hi there! Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me? I have a start date and end date column I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column.…
-
How do I create multiple lines for separate days in a line chart?
I'm trying to create a graph for my production at our tables over a span of 7 days but I can't seem to figure out how to divide them into multiple lines instead of one continuous. The picture of the table is from a report I'm using to feed only those days into it from my original sheet. I need to make sure hours are…
-
Project Plan Template Formula Issue
I have a question on a formula used in a project plan template currently being used. Many times, the % complete (expected) is greater than 100%. The formula currently being used is Expected Effort Complete/Cumulative Effort. The Cumulative Effort is the duration of the task, in days, and the expected effort complete…
-
Setting a date column to the 1st of the Month
I am collecting data for a report and the data i want to show is to include everything from the previous month. At the minute i manually change a date column to the 1st of the current month so that it filters out everything that has been added this month. I have found this formula =MONTH(TODAY()) + "/" + 1 + "/" +…
