Consumer Products
Discussion List
-
Request update only if no recent update exists?In Using SmartsheetAm I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ? I c…
-
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…
-
Rows deleted when deleting columns connected to formattingIn Using SmartsheetHello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I op…
-
Not Receiving Email Alerts for "Changes to New Supplier Setup for Streamline"In Using SmartsheetMy peers setup my profile when I joined Serta Simmons Beddings to get email notification of requests made to add new supplier to Streamline. I am still not receiving the notifications, although my peers are. My profile matches theirs app…
-
RYG balls formula displaying text onlyIn Formulas and FunctionsI've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The for…
-
Dynamic View: Give access for requestors via their email addressIn Using SmartsheetHi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while h…
-
Using IF to look at a Checkbox field and return "XYZ"In Formulas and FunctionsI am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted fiel…
-
Black out dates in a form (date type column)In Using SmartsheetHello, I have created a form and have a column named "Date Item is Needed" which is a date type column. However, the requestor needs to allow at least 10 days from the actual day. Is there a way to always black out those 10 firs…
-
How do I create a cross-sheet formula for a sum $ total within a date rangeIn Formulas and FunctionsI'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as…
-
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…
