-
Using formula in a Date column, then using SUMIF to total
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an 'Personnel Discipline' or 'Equipment Item' to forecast, they then will enter the start and end date and the quantity…
-
Summarizing and aggregating for the same code from multiple sheets
Dear Expert, I have 40 sheets containing following column with example (example for one sheet only): Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price 11MBX21 | AAF | Bearing | 2 | 150 | 300 11MBX22 | AAF | O-ring | 1 | 50 | 50 11MAK10 | BAC | Sensor | 2 | 500 | 1000 11MAD15 | BBA | Switch |…
-
Multiple Attachments in Forms
Hello - I'm currently working with our HR department on utilizing Smartsheet to essentially work as our application. I'd like to be able to have the ability for our applicants to attach their resume as well as their cover letter, however once I add one field in a form, I'm unable to add the other. Has anyone had any…
-
Formula Help
Hi All, I am in need of some formula help! 1. I would like to count all of the projects in my portfolio that are in the Active state and either Yellow or Red health. I have a Dropdown List column for State and a Symbols column for Health (RYGB balls). This is the formula I've have been trying. I am getting the Unparseable…
-
Sharing a Template
I made a sheet and then created a template from that sheet for our department's annual performance review. My manager needs to have access to this template, but i can seem to find a way to share the template and/or make her owner of the template. How can I do this? She need the template so she can set up 20+ sheets each…
-
Help with update requests
Hi all, trying to get my head around automating update requests. I have a large sheet with many columns, each row is a record of an employee, most easily identified by the "email" column which is a type 'contact' and has their valid work email. It also tracks a multitude of events they attended, their reporting manager,…
-
Sharing a Folder
good Morning i have a workspace with 3 differen Folders. Is it possible to share each folder with differen people instead of settin all sharers at sheet level? Regards
-
Jan 10th, 2019: Cell Linking between sheets with the new UI
Is there any updated information for linking cells between sheets with the new UI? It looks like the direct way is still in tact (where you right-click on the destination cell, click on "Link cell from another sheet", and file through the sheets in a pane on the left until you find the source sheet, and then you click on…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Restrict Filter Off Option
Hello there, I reviewed many thread discussions around the Filter functionality within SS, but I still wasn't able to find the answer to my question. Perhaps it got lost and I can't seem to find it, so I'd like to try again... Does SS currently have the feature to only share filters with view only users, specifically, I…
