-
How to create health columns individually in a dash board ? using donut chart or Pie chart?
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?
-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…
-
Does anyone have a simple RFP Scorecard Template they can share?
Hello everyone, I am hoping someone out here can help me. I need a simple RFP scorecard template. Has anyone developed one that they can share?
-
Count number of days in date range that fall in current week
Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours required to complete the task. As some tasks will take multiple weeks to complete, I…
-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Is there any option to share some selected columns in the sheet?
Is there any option to share some selected columns in the sheet? and if they update in the shared sheet automatically it should update in the main sheet. is there any process?
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
How do I share specific rows only?
I want the user to see rows that are assigned to them only.
-
Creating project plan by status??
I am trying to create a simple sheet for creative design requests. -Organized by status (new, in progress, complete) -I want to create a form for the marketing team member to fill out. Once filled, it automates into the appropriate columns (brief, start date, end date, etc. -Then when a request is added, I want to automate…
