-
Help with formula: return value from cell in same row if criteria is met
Hi, I am trying to figure out how to write a formula to return a value from the SAME ROW, when criteria is met. I can't figure out what I am doing wrong with index/match/collect - I am hoping someone can help! Most of the tips/tricks/Community answers I have seen are using columns not rows, so I am not sure how to do it. I…
-
Summary Sheet Formula
How do I write this formula in on my summary sheet? I'm trying get total count of Reggie's "In Progress" tickets. Will this also count if the field has 2 names in that field? For example the field has both Reggie and Jon. =COUNTIF([Assigned To]:[Assigned To], "Reggie Andaya", [Status]:[Status], "In Progress")
-
Need help with setting up a sheet which can pull data and filter it based on certain requirements
I want to build a Smartsheet which can count the total number of submittals that are due within a specific date range (Week starts on a sunday and week ends on a saturday). The submittals sheet is a separate sheet and will need to be referenced to pull the total number of submittals. From there I need to build a formula…
-
Request Approval Workflow Help
Hello! I am trying to set up an approver workflow where after the GM or Director email is entered, it sends the trigger to that specific email to approve or deny the request. When I'm setting up the automation, I used option "Select contacts in a cell" hoping that I could choose the column with the GM email in it since…
-
Auto populate a sheet based on criteria
Hello, I have a sheet that lists of all company projects with Project Names and many columns of associated date. I would like to have a sheet that automatically populates all of the project names based on a criteria. For example project not run in the U.S. One I have the project names in the the new sheet, I can use Data…
-
Using AVG(COLLECT())
Good afternoon, I'm trying to do the equivalent of '"AVERAGEIFS". I read about using the collect formula, but I'm having an error. The formula I'm using is: =ABS(AVG(COLLECT({Master Sheet - 1960 - Net}, {Master Sheet - 1960 - Date}, Date@row, {Master Sheet - 1960 - Info}, [Summary Info]@row))) I'm trying to calculate the…
-
Smartsheet - Formula Help
I have this spreadsheet, What i want to do is basically in hotel nights - I want to be able to do following. The initial date for Hotel nights - I want to set it lets say May 1 2024. then i want the next rows to it to automatically update to may 2 and may 3 and may 4 and so on. the bottom unparsable cell. I want to do the…
-
Need formula for identifying whether a task is a subtask (regardless of overall task level)
Hello, I have a project plan that has 6 levels and am looking for a formula that will identify, in a separate text column, whether or not a task is a subtask regardless of what level it is at. (So only that the subtask is a lower level than its parent task and not that it is at a specific level) As an example, I would need…
-
Need Help with a Formula to Help Generate Chart Widget in Dashboard
Hey Folks, I'm trying to create a Chart Widget to show Metrics for how many lines are down due to specific inoperable Status type and thought I had this worked out but am struggling to generate that formula to do just that. So in essence, pull in a Count that references a specific building for how many of any Status type…
-
Identifying data associated with a previous row
Thanks in advance! From a listing of all meetings, I am hoping to pull in the date of the previous meeting. Note, there are no successors/predecessors with this (I've been able to successfully use Paul's post in other areas to pull in the task name and hoping somehow this could be similar?) Has anyone done anything…