-
Formula to pull in fiscal work week is incorrect
I am continually getting the incorrect work week. In the below screen shot the Onboarded Week should be Week 16. Attached is our lookup sheet from smartsheet. Our fiscal week starts on Saturday, January 29, 2022 and the fiscal week ends on Friday, February 4, 2022. the pattern is 4,4,5 (kinda) you can see it gets a little…
-
SUMIFS with date ranges
Hello, I'm trying to sum the values (Annual Billing Amount) for anything that falls between 2/22/22 and today but I can't get my formula to work. Not sure what I'm doing incorrectly. =SUMIFS({Annual Billing Amount}:{Annual Billing Amount}, {Date to Deactivate}:{Date to Deactivate}, AND(>=DATE(2022, 2, 22), <=TODAY()))
-
Can you please add a find and replace feature that can edit formulas within the selected cells?
This would be a huge time saver! Similar to what is explained here (Find and Replace Values Within a Sheet | Smartsheet Learning Center), but adding the ability for it to adjust formulas.
-
SUM IF with OR and CHILDREN
Hello, I am trying to add one additional condition to this statement below, but can't seem to figure it out. Here's what I have currently (which works): =IF($[Row Identifier - Budget]@row = "Parent", SUMIF(CHILDREN([Alt Cost Center]@row), "", CHILDREN()), "") And I'd like to add an additional option that says if [Alt…
-
Another formula question
Please could someone help to show me where I have gone wrong? I have been through this many times and cannot see why I am returning "Incorrect Argument Set". =IF(AND([Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link…
-
How to track burn rate
I am trying to write a formula for burn rate in smartsheet. (Summary11 - Summary14) / (TODAY() - [Delivery Date]19). I want this formula to extend to [Delivery Date]514 as the data is being entered each day. When I use [Delivery Date]514 in the formula I get # DIVIDED BY ZERO error message. When I include the IFERROR in…
-
trying to add a field to a logic flow
Hello, I have created a field "New Country". I want to use this in a logic flow "Country where work is being performed". The logic: If "other", then enter New Country. However, they system is not even showing me "New Country" as an optional field to pull into the logic. Any idea why? Thank you, Paula
-
WeekNumber & WeekDay error
Can anyone help with a way round the weeknum formula that starts on a Monday rather than a Sunday? I'm using the WeekNumber formula to get a current week in conjunction with the WeekDay formula to create a list of tasks due in a current week sorted by days. Because the dates for when each task is due is auto populated…
-
Formulae help
Hi Team, Can you please suggest on how do I write a formulae that can capture the All Client names separated by "," which are against Red status. The caveat is that the status can get updated periodically and hence today there may be only 2 client against red and tmrw there may be more or less. Can you help
-
Hello, I need some assistance with a forumla
I"m trying to set the status in a field to display blank "" if the Start date has not been reached. I'm using the following formula: = IF([Start Date]@row < TODAY(), "") I think this should work, but it is not. Any help you can provide would be helpful.