-
IF Formula Help
Hello! I'm looking for assistance with creating a formula to return a value on the New Hire Sheet pulling a result from the Offer Sheet. Specifically I'm looking for the following: When the [Primary Column]@row = "Completed" on the Offer Sheet, I need a formula to return the "Candidate Name" from the Offer Sheet in the…
-
Complex Logic Statements
It might not even be possible, but I need to know how to have a cell be populated with a value based on multiple criteria. Scenario - every audit costs a different amount, if it is 2 day or 3 day, remote or onsite, etc. I would like the line item to be able to populate based on column B = number of days and column C=remote…
-
Need help with a formula putting 4 different critera together from 2 columns....
Hello. I have alot to learn about formulas! I have Impact and Effort columns in my sheet. I want to evaluate those numbers (1-6) and give a return in an Impact/Effort Quadrant column. Currently I have this formula which works: =IF(AND(Impact@row >= "4", Effort@row >= "4"), "Major Project") The other variables I need to add…
-
I try to move row and I get an error that does not seems to make sense
here is the error message: There is no formula anywhere in the sheet.
-
Auto-populate 2 cells based on specific info in another cell
I am setting up a sheet as a multiple employee timesheet. It will be a basic sheet and a form will be used to enter time daily. When a name is selected on the form (currently, the Name column is set to drop down with each person's name listed), I want the clock number and class (position) rows on the sheet to auto populate…
-
INDEX MATCH is matching same values to everything
Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what I'm getting: This would normally be fine, as those PO's don't exist on my source (Here is the source sheet) The issue is as…
-
Can I get Unique values on a metric sheet without a complicated work around or report?
I have a column with associate names, over 3,000 rows with over 100 unique names. In order to provide dashboards, I need a dynamic list of unique names listed in that column on a sheet I use to build our KPI metrics. Easy in excel or any other dashboarding tool I use, is this now possible in Smartsheet without using the…
-
Calculating number of 'live' delegates within a specific date range
Hello, I am trying to use a formula to calculate how many 'live' delegates we have on our programme, with end dates larger than for example 01/01/24. I have tried using formulas such as COUNT, COUNTIFS, SUM, SUMIFS but none of these work. I need a formula which will calculate IF status is 'Live', then how many 'live'…
-
Identifying the owner of a row has changed and sending an alert
Hello I have a risk register where each risk (row) has a specific owner (named contact). I want to trigger an alert (workflow) when that owner changes. I've tried building a workflow, but it's triggering when any value in any cell changes. How can I refine this to trigger only when the RIO Owner changes to a new value?
-
How to make Smartsheets act like JIRA when it comes to sprint times
Hi, I wanted to see if it were possible to set the board I created to act like JIRA when it comes to moving cards through sprints. •I have my view in card mode. • I have my lanes created as Current Sprint, Next Sprint, Next next sprint, and backlog just like JIRA. • Is there a way to implement timer using a( formula I am…