-
Send Scheduled Report ONLY to Assigned To resources
I have a Report I would like to send out in PDF format weekly, but only to users who have an entry in the worksheet assigned to them. The report is pulling from a RAID Log, and is configured for Current User. The challenge I am facing is that I don't know how to get around having the Scheduled Report sent to a static…
-
Possible to one file in multiple workspaces?
Hello, Is it possible to have a smartsheet and reports in multiple workspaces? I'm creating a separate workspace for a different team that will need access to the master document which resides in another workspace. The first workspace has some additional reports that I do not want to provide access to. Please advise.…
-
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?