-
Duplicating sheets to have different conditional formatting on reports
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
-
Need help adding a 3rd argument to a COUNTIFS formula
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
-
Sending attachments via e-mail
Is there a way to automate sending attachment (attachment in row) to specific e-mail, when a new row is added? Maybe through Smartsheet workflow, or Microsoft automate?
-
Dashboard - Fillable Sheet
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
DASHBOARD - Shortcut Widget - changed?
I set up a Dashboard many months ago and it allowed me to put Links to WORKSPACES and FOLDERS from the SS Directory. See the Screenshot. I went to update the DB / add another FOLDER, and it would not let me. I had a consultation with a smartsheet basics person on the phone. They said not allowing WORKSPACES and FOLDERS is…
-
Allow multiple contacts per cell AND Restrict to list values only - Not Working
If I have a "contact" type column where I want to "allow multiple contacts" AND "restrict the list to the values" I've added to the column, then the list is not available. If I turn off the "allow multiple..." option, then it works as it should. Is there a restriction on contact type columns that disallows using both of…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
Why does my Start date column and my Received date column put in the same date?
I created this sheet 5 years ago to log contracts when received, the start date and end date. Just about a month ago, my start date and received date column input the same date. As if they are linked or joined but I cant see anything. Has anyone else had this problem? What can I do to fix it. I am now concerned this may…
