Retail
Discussion List
-
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…
-
Unable to Scroll While in a FormulaIn Using SmartsheetHello, I am unable to scroll while editing a formula. For example, I am in line 648, and need to make it equal to line 45. If I simply hit =, and attempt to scroll out of view from 648 it gives me a #UNPARSEABLE error. I have been usi…
-
Integration with ServiceNow, the ITSM toolIn API & DevelopersWe use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in ServiceNow to an action item in SmartSheet w…
-
SFDC Connector - Snapshot Then TrackIn Apps, Integrations, and Add OnsI know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My…
-
IF THEN formulas for status ballsIn Using SmartsheetI am trying to use an IF THEN formula to show status balls. I have a "due date" column and a completion column. If the date in the completion column is more than 7 days later than the date in the due date column, I'd like the sta…
-
Can you do if this then that for auto entry from drop down listIn Archived 2017 PostsI want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"th…
-
Automation: Request an update but my contacts are not in a contact columnIn Formulas and FunctionsI'm working on a sheet that has a formula that is running an INDEX/MATCH to populate the Carrier Contacts based of the trucking company's Unique SCAC code. The fomula is working great now and I have the cells populated with the email cont…
-
Image Widget Linked to a specif set of rows in a sheetIn Using SmartsheetDoes anyone know if there is a way to link an image widget directly to a selected amount of rows in a sheet? I currently only see the option to link to a full sheet, but want to direct the user to a certain section of the sheet.
-
Automation: Request an update but my contacts are not in a contact columnIn Formulas and FunctionsHow can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" sinc…