Formulas
Discussion List
- Below is a formula I found here in the Community. While the first name worked, the last name didn't. Well, it did but the comma is appearing. I also noticed that if the hyphenated name is lenghty, it …
- Hello, I'm looking to extract the first 3 letters in the word that follows the first occurence of a space. Here are some examples: Budgeting Building Relationships Changing the Language Holding People…
- Hello, Im trying to get a min of 4 if PA points and SS points are both active then have 4 or the number that is either ss or pa add to the other columns, is that possible? Here's the formula I came up…
- Hello Smartsheet Community, I am currently working on a formula that needs to reside in a metadata sheet and am facing a challenge with multi-select dropdown columns. Specifically, I need to count row…
- The rows will be children of a same group. I am trying to make a simple checkbook style sheet and I want users to be able to add rows and have the all the formulas and formatting iterate down. From th…
- I'm trying to do something that seems simple but is really frustrating me. I want to copy certain rows to another sheet and mark them 'done' afterward. I've got an automation that copies rows over to …
- I need a column formula for Smartsheet considering the following: The first row must fulfill this formula: =BUDGET@row - [AUTHORIZED AMOUNT]@row From the second row onwards, it should be like this: =B…
- Good Morning All, I need a formula to count the running total of the Dealer Names as they appear. The current formula I have in Column 14: =COUNTIFS(Dealer:Dealer, Dealer@row) is showing the total tim…
- Hi all, Formula assistance required. I have a transaction log and I want to evaluate the transaction log to find the latest date(Max formula assumed) and match a cell (Match/ Vlookup / Index / Unsure)…
- I'm trying to use =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@row), {Project PI & Sprint-End Date}, >=[End Date]@row, 1) but its not working I…