Retail
Discussion List
-
COUNTIFS formula with yearIn Formulas and FunctionsI'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found thi…
-
SUMIF Formula - Incorrect Result?In Formulas and FunctionsHello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflowIn Formulas and FunctionsI have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to us…
-
If with dropdown listIn Formulas and FunctionsI'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, cou…
-
SmartSheet Jira IntegrationIn Archived 2016 PostsHi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it…
-
cell.format currency settingsIn API & DevelopersI'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the …
-
Surveying Project - How to setup the structure of SmartsheetsIn Using SmartsheetI need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of W…
-
Approval flow for credit notesIn Formulas and FunctionsHi all, I have set up the first draft for an approval flow to draw up credit notes. At the moment I have a flow set up as test that works very well for 1 condition - but I need to have a flow that includes 3 conditions: - credit note app…
-
Automate RYG Balls based on 3 columns.In Using SmartsheetHi, I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green. Tha…
-
Help Combining CountIFs and TODAY() functionIn Formulas and FunctionsHello, I am having difficulty with the proper syntax in my countifs function. What I am trying to do is count the instances of a word within a specific column (this I accomplished without a hitch) and then narrow those by instances that a…
