-
Sumifs with multiple criteria including one Multi-Select column
Hello - I am trying to sum a grant $ amount when one column is marked "Yes" to COVID-19 Related and the other column is either marked "Approve" or "Approve-Repurpose". I can't seem to figure it out. Can someone help? =SUMIFS([Grant $]6:[Grant $]350, [COVID-19 Related?]6:[COVID-19 Related?]350, "Yes" AND([Approve/Repurpose/…
-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Count average time to close action
Hey, Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of the time from when the date raised changes to a value and return a value in the time…
-
Help with vlookup/index/match
Hi, I'm trying to create a table that looks up data from a list of entries based on multiple criteria. I have been able to achieve PART of my task with different formulas but can't figure out how to achieve my desired end result. I tried Index/Match, vlookup/match but can't get it to work. I want the formula to be dynamic…
-
Determining a Weekday Start Day by Referencing a Calculated Field
Hello, I'm trying to determine when to start a project based on the due date and the effort. The effort exists in hours and I've converted that into days based on a 7 hour day (padding days to allow for admin/other work in a day). This is my WORKDAY formula: =WORKDAY(Stop109, [Effort (#Work Days)]109) However, when I try…
-
Why does my Modified Date keep updating when I'm not making changes?
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows at all. In many cases those rows are filtered out of my view, so it's not even…
-
Link Data in a Smartsheet on a Specific Day and Make Static
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new…
-
Formula
Hi There, I have a list of requests that have dates that were created, so I want to run a report for all the requests that have been opened in the past 6 months from the date I am presenting my report on. Is there a formula I can use to do this calculation as I want to add this as part of my dashboard? Kind Regards Nkosi
-
SUMIF
Hello, I am trying to create a sumif formula to work out a value of column each time a name appears in a different column. I am currently using the below but it keeps coming back with #UNPARSEABLE =SUMIF([Assigned 1st]:[Assigned 1st], "[Nicola Sutton]", [Job Value]:[Job Value]
-
Turn Flag on if there is a Date in Date Completed
Simple question but not for a newbie! I would like for the Task Complete flag to show when the Date Completed field has a date in it and to not show a flag if no date. I know this should be a simple IF statement but I got stuck. Perhaps use ISDATE?? I tried this in the column for the flag: =IF(ISDATE[Date Completed]13,…