Retail
Discussion List
-
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…
-
Formula to return data from last row of a sheet of dataIn Formulas and FunctionsI am working on a dashboard and I'm using a intermediate sheet to collect data from other sheets of data. Typically the data is entered in each day so I was able to have the formula for most cells to look at the referenced sheet and retu…
-
Help with Collect / Match / Vlookup formulaIn Formulas and FunctionsWorking on a collection of sheets that I use between the different staffing agencies that service my operation. My Sr. Ops manager publishes a sheet (with the green shaded cells in the attachments below) with the labor order (by agency) e…
