Formulas
Discussion List
-
Formula to return a date that always lands on WednesdayIn Formulas and FunctionsHi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)&l…Answered - Pending Review 9 views 3 comments 0 points Most recent by bcassidy33 Formulas and Functions
-
How to display Name of the user who created record?In Formulas and FunctionsCreated By displays email. How can I display the actual Name of the user who submitted record through form?Answered - Pending Review 15 views 1 comment 0 points Most recent by Krissia B Formulas and Functions
-
Another Nested IF FormulaIn Formulas and FunctionsCould use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biol…
-
How to Send Timed Reminders Based on a Trigger?In Using SmartsheetHi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declinatio…
-
Using COUNTIFS with CONTAINSIn Formulas and FunctionsHello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("…
-
Summary formula Sum of informationIn Formulas and FunctionsHi All Can anyone please advise on how to quantify two columns in the Summary information? I want to look at the failure column to look for keywords then sum the amount of failed items. Example look for ... OTIF and the sum of issues sho…Answered - Pending Review 8 views 1 comment 0 points Most recent by David Clunie Formulas and Functions
-
Bring the data in a cell over to another sheet based off of other conditions in a rowIn Formulas and FunctionsWhat would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, &quo…
-
Dashboard with Filters - Best PracticeIn Formulas and FunctionsHi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this…Answered - Pending Review 1.9K views 7 comments 0 points Most recent by cmore04 Formulas and Functions
-
Cross Sheet Joining AutomationIn Formulas and FunctionsHello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox th…Answered - Pending Review 62 views 3 comments 0 points Most recent by Devin Lee Formulas and Functions
-
Ranking without Duplicating RanksIn Formulas and FunctionsI used the RANKEQ function for the first time recently and realized that any identical values will have the same rank. It will skip however many duplicates you had in the ranking numbers, so you may have a ranking scheme that looks like 1,…
