-
Project Task NETWORKDAYS (standard calendar days) spanning different accounting calendar days
My organization's accounting calendar varies from a standard monthly calendar as shown below. I am trying to determine a method of calculating the number of NETWORKDAYS within a project task span that falls within each month's corresponding accounting calendar span. It is simple enough if the entire project task fallsโฆ
-
Cell Linking - Updating Source Sheet
Not sure if this has been answered before and if so, apologies, I could not find anything relevant. My team has been trying to link from a 'schedule' sheet out to smaller sheets so that we no longer have to manually update the smaller sheets. Unfortunately, we have found that whenever we need to update the linked cells inโฆ
-
Looking to return a value given a specific row and column
I would like update a goal target automatically based on today's date from a matrix. Through "=Today" , I have established the current year and current month. From there I want to populate the yellow cell in the "Current Goal" column for either "Annual" or "Cumulative". This cell will then be cross-linked to a metricsโฆ
-
Using "If" with dates
Hi all, I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.). I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100%โฆ
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts ofโฆ
-
RGYB color change based on Status
Hi, I have gone through a lot of posts in this community and tried a bunch of formulas and can't get it to work. I have 5 statuses in the Status column dropdown Not Started In Progress Delayed Behind Complete I would like the RGYB colour to change based on the status. Not Started, and Complete - Blue In Progress - Greenโฆ
-
COUNTIFS - Multiple Columns if blank by person
I am looking to count by the person if they have not entered data in the cells within a column. If person A is missing six (6) cells within three (3) different columns then the calculation should only calculate that person one (1) time. I have created helper columns to calculate how many people have missed entering data.โฆ
-
Need help getting a Date which is linked by a predecessor to default to the nearest Thursday
Hello all, I'm looking to get a date to populate by pulling a predecessor, but default to the nearest Thursday from that date. I have tried several formulas but am not able to get this to work. To break it down more, I'm looking for the First Guest Check-in Date to be the Thursday after the Contingency End Date see imageโฆ
-
Help with this IF this then this formula
Please help me figure out what I am doing wrong with this formula: =IF((([Size of Install]@row = "Small - Single Server, no HA, no NLB, HPAC PP+IA+, no HPAC Scan, no HPAC mobile connector, includes PPM/PDM, WJA, UPD, 500 printers or more - remote/travel extra, for small AlertX configuration only, single server for PP,โฆ
-
Formula to check KPI Met box if Current Review Complete is less than Complete Update Due By...
Hello! I need a formula to check KPI Met box if "Current Review Complete" is less than "Complete Update Due By", however if the Current Review Complete cell is blank, do not check the KPI Met box. Thanks so much for your help!