-
Calculating the quarter complete
I have a formula that calculates the Quarter complete. It worked great at the end of last year, but now I have some programs that will go into 2022, and I need to differentiate between Q3/Q4 of 21 and Q3/Q4 of 22. I thought by using the YEAR function that would help, but alas I get the dreaded syntax error:β¦
-
I would like to reference a cell using the column name & a number from another cell for the row #
I am using Predecessors in my sheet and I am trying to figure out a way to see if the predecessors has been finished based off a check box. Is there a way to make something like this to work? =IF(FinishedPredecessors@row = 1, 1, 0) I would like to take the number from the predecessor cell and use it to reference which rowβ¦
-
Is there a way to customize rules for duration calculations?
I'm using Smartsheet to manage contracts and their critical dates. The critical dates of these contracts are typically written with a rule set that any duration given with 5 or less days is to be counted as business days (weekends are excluded from duration count, and if the end date lands on a holiday then it moves to theβ¦
-
Calculating Percentage
Hello, I am still new to Smartsheet and struggling with formulas. Grateful id someone could help me with a formula for calculating the percentage of C-Section in column 3 below.
-
Countifs with Contains function
Hello, I am having trouble with this formula. Basically we have a list of employees with a column for their position, and their schedule. If they are in training, the schedule starts with "Effective" followed by the date they leave training. I am trying to pull the number of people in each position that are in training byβ¦
-
Can locking rows also freeze formulas from updating when conditions are met?
I have a sheet that I am using formulas to pull in data for various dates (IE totals based on COUNTIFS formulas). The records that the data is coming from will continually update so in the example below what I would see is on 8/1/21 the number being 100 and the next day for that date the number being 50. Ideally, I wantβ¦
-
COUNTIFS formula with date fields is giving me trouble
Hello, Formula Gurus, Every other COUNTIFS formula I have on my sheet is fine. Since this is the only formula referencing date fields, I suspect that is where the problem is. Formula: =COUNTIFS({MedschedulerAcademicYear}, ="2021-22 August 23, 2021-August 21, 2022", {MedschedulerDate}, <DATE(2022, 3, 27),β¦
-
Can I create a dropdown to lead to another page?
Hey guys, trying to create a dashboard where I could have different dropdowns and hoping that when someone clicks on the option, it could lead them to another page. Is this possible? If not, any ideas on how I could execute this. We are trying to create a one-stop-shop where our team can click on something and lead them toβ¦
-
Can an attachment be referenced in an Alert messages like other columns?
I have an alert set up to notify management when a new status report (attachment) is added to a sheet. Each status report is attached to a single line in the report history sheet. I'm sending a simple message to non-Smartsheet users with some basic info from the sheet using {{column name}}, but to get the attachmentβ¦
-
Countif and formula
Hi I am trying to create a formula that counts how many times "Engineering" appears in a column when the column next to it that is either "Delayed, Set Back, At Risk for Delay" Here is what I tried: =COUNTIF([Critical Action Department]2:[Critical Action Department]51, CONTAINS("Engineering", @cell)AND([Task Status Basedβ¦