-
last, first to first last
I want to flip a column which will be last, first names and return first last. So Doe, John becomes John Doe I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is not helpful. Last Name Formula: =LEFT(NAME31, FIND(",", NAME31) - 1) First Name…
-
last, first to firstname.lastname@mycompany.com
Is there a way to take a column: Last, First and build Firstname.lastname@mycompany.com Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no control over the original spreadsheet, (so cannot have the sender manipulate the data in…
-
SUMIFS Multi Criteria Function
I'm trying to sum a total using two criteria and it won't work. I can do the sumif for each criteria seperately but when I try to do the "ifs" one to combine the criteria it says "unparseable". I have these fields in one sheet and trying to sum them in a separate sheet: Month/Year Manager (as a Contact field but I don't…
-
Why is INDEX slow?
Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those columns have formulas. These sheets now use summary fields, some of which derive their…
-
Highest value on the last six values of data
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
-
Combining IF(AND statements with Dates
Hi - I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails. First date…
-
How do I set a formula for an entire single select drop down column?
I am pretty new to using SmartSheets and I've just figured out how to use formulas! I've been searching everywhere but I can't seem to figure out how to set a formula for an entire column. I want the formula to be automatically be applied when a new row is added (these rows are brought in via responses to a form). This…
-
using SUMIF / SUMIFS
im now starting to become formula blind, help i have 1 column with a reference to use as the identifier, "1-3" in the image, but i want to SUM up all the values in multiple columns! But the only way i can get this to work is looking at a single column for the argument rather than using the left column to then SUM up all…
-
Formula: Start date + 1/2... days
Hello community, I am trying to add a formula for the following: The date in red is the start date (DATE1). The dates below should be programmed like DATE1 + 1day, DATE1 +2days etc. I tried different formulas I found in the Learning Center but for some reason it didn't work... Thank you for your help! Elizabeth
-
Dividing a value under "1" i.e. 0.71 isn't working
OK, so I have a sheet that's giving me some details on contract spend. One column is telling me the remaining value in a contract, another column is telling me how may weeks are left until the contract expires - i then have a 3rd column that is calculating how much weekly spend is available before the contract expires.…