Consumer Products
Discussion List
-
Vlookup from Excel to SmartsheetIn Formulas and FunctionsMy apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and cit…
-
Formula Refers to Worng RowIn Formulas and FunctionsI have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the prima…
-
how to see the collaborators ?In Using SmartsheetI don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
-
Pivot App - Transfer of OwnershipIn Apps, Integrations, and Add OnsI was wondering what would cause the, "Error! Target user doesn't have sufficient sheet/report access.", error when trying to Transfer Ownership of a Pivot Sheet, from one License to another? I own both Licenses, and they are als…
-
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…
-
Invoice approvals after form submittedIn Using SmartsheetHello! I am trying to set up a process where employees at my company fill out a form, attach an invoice and then I route for approval from my sheet. I need to figure out some sort of way to save both the invoice that was attached along wi…
-
card view filter - include summary tasksIn Using SmartsheetI commonly have task lists that are nested to an arbitrary number of levels. In card view, you can filter tasks to level 1, level 2, etc. This isn't very useful to me. I think it would be far more useful to have a filter "include summ…
-
Changing column Property Status (Red, Yellow, Green) when two columns dates are differentIn Formulas and FunctionsI am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Deliv…
-
Notifications aren't being sentIn Using SmartsheetHello! I've had a notification set up since March that sends to 2 other people besides me whenever I add or change anything in my Smartsheet. It worked beautifully until July 4th. I've changed nothing, but the notifications stopped sending…
-
Radar ChartsIn Using SmartsheetHi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?