-
Download workspace sharing report (csv) is not working
Hello Team, I am not receiving any emails to download my workspace report. I tried this multiple times in last 3 hours. Can you please revert back? Thanks
-
IF Statement w/Drop-down Multi-select
Hi folks, I'm trying to create a formula focused on two columns (one a single-select drop-down and the second a multi-select drop-down). Based on the value in the single-select drop-down, I'd like the multi-select column to include multiple selections. My attempt at the formula is below: =IF([Change Requested]@row = "New…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…
-
Formula to Forecast Material Quantity Received vs Consumed
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
-
Using Multiple Checkboxes to determine and auto-update % Complete
I have some tasks for an implementation Smartsheet that require different steps. I would like the % Complete column to auto update to 33%, 67% or 100% based on the boxes checked. Obviously if the final box is check it would be the 100% and ignore the 2 boxes that came before it. I attached a screen shot with the formula I…
-
Consolidating output from multiple forms onto a single line in a sheet
I am quite a new user so apologies if this is quite a simple task I have a multi stage process which relies upon collecting information from 3 different sources (for which 3 forms have been developed), but as the information all relates to a single request to procure a vehicle, which is being tracked on a single sheet, i…
-
Suggestion — Add a formula to retrieve information about the comments in a row
It would occasionally be useful to be able to access information about comments within a formula. For instance: IF(CountRowComments() gt 0, "Has comments!", "No comments") Or even, IF(GetComment(1).Contains('error'), TBD, TBD) (Don't take the syntax too literally, but hopefully you get the idea.)
-
Widen attachment column
My attachment column is so narrow you can't see the paperclip icon. I can not click and drag it wider. I need colleagues to be able to see the symbol so they know something is attached. How do I fix this?
-
Create a Map chart?
I'm looking to create a map chart within a dashboard (namely, a chart of the United States, with data in each state visible when hovering over each state). Has anyone done this that can point me to where to get this done? I've seen them in Excel, but have had no luck for this capability in Smartsheet.
-
How do I set an automation without a trigger or is there a workaround to create a trigger
Hello! I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time period after it is locked by the first automation. Essentially I want to ensure that…