This is probably not possible, but this group is amazing and may have other ideas. I have an ORDER sheet that list various products and services (ITEM DESCRIPTION) into 5 different MARKET(s). This cou…
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am work…
I'm trying to implement a formula that will reference the name of the rows Top/First Parent for each row. I have reviewed other threads on this and have not seen a definitive solution (or just one I c…
Hello I need a little help if possible Original Formula: =INDEX({Jira MMP's Validation Results - Jira Status}, MATCH([Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0)) Which worked perfectly …
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, …
How is it possible that there isn't a RANDOM() function in Smartsheets to generate a random number of a specified number of digits!? Am I just missing something? Anyone have any clever workaround? Jus…
Hi everyone. I have a formula for which i have multiple criterion. The issue I am having is for one of the columns, I want it to be counted if it contains "x" or "y" or "z". I cant figure out how to p…
Hello Formula Gurus! Do any of you have a formula that will return the "week starting" date based on a created date? So evaluate the created date of a row and bring back the date of Monday that week. …
I'm having an issue with the Logical Statements when using nested =IF() statements. Essentially, it's not following the Logical Statements correctly. Here is an example of a formula that is failing: =…