-
Help creating formula for project prioratisation
Hi there Im fairly new to Smartsheet and was looking for some help creating a formula to help populate the score for each project within the team, to then help prioratise each project. Have found a useful Smartsheet excel template and corresponding formula but cant seem to apply that to Smartsheet. Below is the criteria…
-
How to Separate Text?
Hello, I have a list of names and I want to separate them by last and first name. I am not seeing a function to accomplish this in Smartsheet like you would in excel. =TEXTBEFORE(A2,",") and =TEXTAFTER(A2,",") Full Name Last Name First Name Barbosa, Fred Barbosa Fred Any suggestions?
-
Having a tough time with time calculations
Hello Everyone, I have been referencing the Time calculation post: How do I create time of day columns? - Smartsheet.com For some reason the very last formula listed below returns all the minutes as "00" instead of the actual minutes. I am basically copying the formulas listed in the above link except I never have to worry…
-
Formulas to Add Meeting Date and then Corresponding Due Dates?
My company has a regular meeting with a client, with required notes due 3 days later, for several years. I am looking for formulas that will help me do this efficiently, but I haven't found answers with searches. 1) Is there a formula/function to find the last Monday in a month? This info would go on the monthly meeting…
-
Count Multi-Select with conditions
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it…
-
@Column Reference
I have a formula that I would love to make into a column formula but am unable to because I reference a cell (a helper cell I have in the first cell of the column that is the same as the column name). Without being able to use [column name]1 in a column formula I am unable to have it be a formula that can be easily copied…
-
How do I return text from text string with the space as a delimiter?
Hello, I am trying to extract each word, or a set of words from a text string that has spaces in between. Example: AW (Ground) AIRTOP Tropical Day Cart 500mL How do I just return each word by itself in different columns? Thank you!
-
How do I write my SUMIF formula so that it automatically sums numbers in its own column?
All -- I am putting together a SUMIF function for Column Beta that adds together only those column entries whose Column Alpha have a specific value. This gets me: =SUMIF(Alpha5:Alpha56,"Value",Beta5:Beta56) According to the Help & Learning article on SUMIF, the "Beta5:Beta56" part of the formula is called the "sum range."…
-
Duplicate Helper column with filter
Hi! I'm trying to build a formula where I search for duplicates within one column (Job Numbers) but only if "Invoice" has been selected in another column (Deliverable Type). I was able to get a formula to search for duplicates working but it is searching all the deliverable types, but I just need to know if there is more…
-
How could we convert the day to year?
i have tried to number of days divide by year, seems not working
