-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Counting and Dates
Hello, I have been trying to come up with a formula that works. I am trying to count all of the "request" I have through a certain date. The form that I am using to take requests and the sheet that I am tracking metrics are separate. =IF(AND({Intake}) > DATE(2018, 12, 1), {Intake} < DATE(2018, 12, 31)) This is what I am…
-
Counting cards according to their status
Hi. I have four projects, each assigned to a unit division. Each project has tasks in different implementation stages. By default, Smartsheet counts how many tasks are in each stage (column). I want to use that counting to display in a dashboard, so I can see the status of tasks implementation by unit division in a single…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Automated Status Ball color change
I have the following formula shown below that changes the Status symbol (Gray/Green/Yellow/Red) based on the Phase/Risk/Change Implementation Date. I tried to update it for a new Phase "Canceled" but I keep getting the error #UNPARSEABLE. Is this due to the fact that I'm trying to have both the Phase "Operationalize" &…
-
Is it possible to have Sheet A populate information into Sheet B if a checkbox is checked?
Is it possible to do the following: Sheet (A) - A checkbox is checked in Row 4 Sheet (B) - Automatically pulls in a text-field that is in Row 4 If so, how? The purpose is to roll all "At Risk" Description Fields into a summary sheet for the executives to review. Reports won't work for they need to be able to type their…
-
autonumber column exceptions based upon a checkbox
I have an auto number column that I use to assign an employee number to new employees. From time to time we re-hire a termed employee, in which case we do not need a new number - we would just use the old. I have included a checkbox if the employee is a rehire. My questions is - how can I have the auto-number column not…
-
Nested IF , logical operator (AND)
Hi All, I am trying to build a formula with IF, AND conditions but i am unsuccessful, can any one help me to sort out this please. Here is the forumula =IF(AND([Position at Practice]227 = "Receptionist", [Current MECA Step]227 = "Step 1"), "19.63", IF ([Position at Practice]227 = “Receptionist”, [Current MECA Step]227 =…
-
Date Calculation
I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really…
