-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Product Submission Warrant form
Anyone using SS for PSW's? I;m thinking it would be a great way to have suppliers submit their Inspection reports, PPAP reporst etc. Any thoughts?
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Event Registration - Link to Webinar
I'm using the Event Registration template for people to sign up for a webinar and I'd like to send registrants a link to the webinar after they register. The only way it works is if I include the option to send a confirmation. BUT, the person registering has to click that box and I can't make it a required checkbox. I know…
-
Dynamic Template
I want to create something that is several columns containing data is is continually updated - but only added to, no content is ever deleted. I'm calling this the "template". I'd like to be able to pull the "template data" exactly as it is - format, parent/children, text, etc AND as it changes into other sheets so that…
-
Gantt timeline
Hi! I'm finding the Gantt timeline zoom options quite restrictive/extreme. Does anyone know whether there is way to either: - Zoom the timeline more variable than the standard extreme settings - Show 12-months' worth of timeline Thank you! Steve
-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Automating RYG balls based on Due date and completion status
Im having an issues creating this formula and was hoping someone could help improve on my formula. Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and "Red" if the task is past due. However, the HEALTH flag should stay blank if: 1) the STATUS…
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
