Retail
Discussion List
-
Collect and display nearest datesIn Formulas and FunctionsI have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns be…
-
Notification with AttachmentsIn API & DevelopersHi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If…
-
Document Management SystemsIn API & DevelopersHello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
-
Volunteer AllocationIn Formulas and FunctionsHi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
-
Parent Row % Complete Doesn't make any senseIn Formulas and FunctionsSee attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(…
-
Can I have rows in card view?In Using SmartsheetI'm trying to determine if rows can be included / added on card view. I have my lanes setup to view by status (ie not started, in progress, blocked, complete, etc) but would like to have rows also to separate my cards by team or possibly a…
-
COUNTIF by MONTH in Sheet Summary FieldIn Formulas and FunctionsHello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in…
-
Email User Completed FormIn Using SmartsheetI have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
-
Flag if date created > 48 hours and completed column is blankIn Formulas and FunctionsHello, I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias: 1. if the date created has bee…
-
RYGB symbols automated to reflect status/progressIn Formulas and FunctionsHi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what ne…