-
Purchase Orders and Invoices Tracking Template
Hi - Am wondering if there has been a template designed to maintain hundreds of purchase orders along with the associated invoices that get billed every month. A view that would allow me to see which purchase order has been fully invoiced, or which vendors we need to contact to complete the process. I need to know how much…
-
Form: Require "Need order by" field to be AFTER today.
We have a form that has a DATE field called "Need Order By" so that the user can tell us the date the the order must be fulfilled by. Can you guess what date users MOST OFTEN use? Yeah, you got it! a date in the PAST. We are very anxious to find a way to force the user to input a date that is in the FUTURE. Can anyone tell…
-
Sheet summary report not showing all columns
So i was trying to edit a sheet summary report that was built from someone prior to me and i was struggling to make the necessary changes so ive made a new summary report, however, i am running into the same issues. For some reason the column options in the sheet summary report are not all of the options that should be…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Checklist with auto-filled data
Hey guys! I have a fun scenario and wanted to see if anyone had any ideas. I am a Mortgage Processor, and we have to track and obtain a lot of documentation for each individual loan. We currently have a Word Doc template that we use as a Checklist of sorts when we are reviewing each file, and we use it to track any…
-
Bridge: Failed to parse module params : Required parameter Sheet has not been defined
Hello, I am trying to figure out a resolution to my workflow. Parent Workflow: Trigger: when new row added, with filter to Search the sheet that is flagged (have formula to flag newest submission in source sheet). It is successful and the array contains the data that will be utilized in the child workflow….until… it…
-
Cross Sheet Reference Maximums
Hello! Does anyone know if cross sheet reference maximums increased since Engage? I know sheet capacity increased and cell link capacity increased, but I don't recall cross sheet references specifically being called out. As far as I am aware (and is still documented: Smartsheet Help Page), there is a maximum of 100 cross…
-
Parse-ing
Hi Brain Trust I have a sheet that has two Compliance & Training Columns 1/ Job Requirement 2/ Candidate Compliance Check 3/ Helper columns that reports the Count difference between 1&2 - this then triggers conditional formatting and a symbol Column I have been asked to - when drop downs are select in the job Requirement…
-
I cannot transfer ownership of a sheet to a licensed Admin user.
I want to transfer two sheets from my personal account to an admin account that owns all of our sheets in the company. The admin account is a licensed user, and is currently listed as an Admin on the sheets in question. However when I try to give that account Ownership via my own account I see a crossed out icon when I…
-
How to Make a Dynamic Formula for Multiple Searchable Values Using CONTAINS or HAS?
This discussion was created from comments split from: Contains formula not picking up text.
