-
Linking to other sheets
Hello - I'm attempting to create a worksheet that would be our tracking for specific system setup requirements (checking the box that things are complete). I would also like to be able to allow for approvals, however I don't want each specific field being included on the approval. I was thinking of linking cells to another…
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
-
Software uses
Is there any construction companies out there that use Smartsheet other than for job tracking and HR? Maybe budgets and scheduling manpower? I need some ideas on how to set up those activities on smartsheet. Thanks!
-
Formula to get averages from one column if another column is checked
Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…
-
Counting number of tasks, by top level then by RAG status
Hi everyone My project has 4 Level 1 Tasks and about 300 sub tasks at up to 5 levels. I've been asked to count the 300 tasks by top level task, split by RAG i.e. Top Level Task 1 (100) - Red (3) - Amber (27) - Green (70) Top Level Task 2 (150) - Red (2) - Amber (8) - Green (140) etc The card view is good for counting RAG,…
-
How to Create a Purchase Order
Hi, I am trying to create a purchase order form from data stored in an Order intake form sheet. I need to be able to take certain fields from the intake form sheet one line at a time and create a standard looking Purchase Order in PDF that I can send for execution via DocuSign. Thanks! Alex
-
Best way to share specific rows for edits
Hello - I have a SmartSheet containing several rows with thumbnail images and product information. Hundreds of additional rows will be added as the year progresses. I will need clients to review and add information for groups of rows at a time. As to not appear overwhelming, is there a way to only share the rows that are…
-
Tracking purchases
Trying to assist my purchasing department... I've set up a sheet for a department to enter their purchases, but my issue is that our purchasing dept wants to have it itemized. For example, I might have an Amazon order for $1000.00, but that $1000 is comprised of 1 printer that's $500 and a computer that's $500. I'd like to…
-
Wrapping text
Hi, Is it possible to ensure that wrap text is assigned at all times on a sheet? I seem to be adding lots of detail to numerous rows and I have to constantly select the wrap text icon for each row - it would save time if wrap text could be applied to all rows on a sheet. Thanks Tom
-
need blanks instead of #invalid data type
I am trying to have smartsheet calculate the difference between a start date and end date, but I will never have all dates in the sheet. I need it to return blanks when either start or end date is missing instead of #invalid data type. Can someone please help? I already tried a conditional formatting rule to white out the…
