-
Formula modification help.
I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula? =SUMIFS({Time Tracking Range 4},…
-
Autopopulate Date based on contract renewal terms
Hello, I am looking for a formula that would help with calculating a date based on dates and criteria in two other columns. Here is the scenario: I have a contract with an expiration date. This contract is auto renewed for a certain number of years (3, 5, 7). I would like to create a column that contains a formula that…
-
Help with MAX Function
Hello, I need help writing a MAX formula to return information by the latest creation date. My current formula is =IFERROR(INDEX({CS PT Recruitment Candidate FirstName}, MATCH([Workday PID]@row, {CS PT Recruitment PID}, 0)), ""). If we recruit for a position multiple times in a fiscal year, the position ID remains the same…
-
Subject line of email notifications
Hi all, My team uses the chat feature in a shared spreadsheet. We receive email notifications from Smartsheet when someone has replied to a chat we're following, or if we get tagged in a chat. Is there any way to customize the subject line of the email notification? Thanks, Christina
-
I am trying to sum a column when the checkbox is checked, what is the formula for this? Thanks
I have a column named Spend and a Live column with a checkbox. When the checkbox is checked, I want to take the dollar amount from the Spend column and add total them
-
Can I include a date from another sheet into a formula for my current sheet?
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project? Basically like this:…
-
Count between ranges
Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges. In my example - I want to count a category name AND only if the % Complete range is between 25% - 49% FORMULA =COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49) As mentioned this seems…
-
CONTAINS a blank in region
Id like to create a formula that looks across 5 or so rows, that can report if any are blank. Ive tried to use CONTAINS but it doesnt appear to work when i use "" to signify finding a blank cell. Online Help seems to suggest that i need to use IF with CONTAINS to gain my result. Do i? I get something to work with bu doesnt…
-
Using Contents from one Date cell to update another Date cell
Im trying to use a 'helper column' to run a formula that checks the contents of a date column/cell, and copies those contents to another date column/cell. The code I'm using is quite simple, so I feel that I must be making a silly error, or it is not possible. To re-iterate, I have a cell specific date column , and I want…
-
Approval Workflows not sending out Alerts
I am setting up an approval workflow, which has branching alerts based on if it's approved or denied. I received the email asking for approval and am able to add a comment and make a selection. Once I do, it is supposed to send an alert to a specified person. No matter what I do it never sends this alert. It adds the…
