We are a small company and we need use of just ONE sheet to be able to send to customers for them to be able select drop-downs (and a little bit of free-type) to create a bespoke item. Looking into the pricing etc on Smartsheet it is going to cost us £684 per year!! Is there any other way that we can do this slightly…
Hi Just thinking aloud... is there any reason why I couldn't import my product inventory into 'contacts' and use the 'contacts' feature as 'products' and be able to select multiple products in one cell on a row? And then do counts of products within a sheet or a selection of rows? Thanks Cheers Richard
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
I know that one can insert a row above the current row and there there is a keyboard shortcut for this. It would be nice to have a way to insert a row below the current row as another option for inserting rows. It would also be nice to be able to insert multiple rows at once (above or below), by highlighting that number of…
How many characters are allowed per comment?
The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc). For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from…
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
I have multiple sheets that all lead to a "Totals" sheet on the first sheet. This project is based on caseloads in a school system. Each "sheet" is its own school in the system. I have a drop-down on each sheet for the speech teacher for that school, as well as total hours of service time needed at each school/week. I need…
I have a sheet where issues are logged. The primary is a record ID, I have another column "Assigned" which has 7 names in a dropdown. Another column is "Field" with 9 options in a dropdown. I am trying to create a formula that will lookup unique pairs from Assigned and Filed and count the number of records for that…
How do I automate the workflow from Person A doing task 1 to Person B doing task 2 and at the same time automate the measure of turnaround time and not being overridden by collaborators? Thanks