-
Column labels?
Hello all! I am brand new and have no idea what I'm doing yet. lol! I was wondering, is there a setting that will label colums like in Excel (A,B,C etc). I can't tell if a column is hidden just by looking at it. Thanks in advance for your help! Jennie
-
Trying to create an IF THEN function in smartsheet
My example is to select an material size value based on the material. Something like this: If [cell1]="4X8 Sheet" then [cell2]=32, if [cell1]="4X12 Sheet" then [cell2]=48, etc, etc. I have a dropdown list in the materials column to restrict the set of possible materials. Subsequently, I would like to take those values to…
-
Weekly Automated Staus Emails to Clients
I'm running a landscape installation company in Smartsheet and I'd like to set up a way to send an automated weekly email to the client's email address stored in a contact column with their jobs that are coming up in the next few days. In my sheet, each row represents a job and I have a start date. I see that I can filter…
-
"SUMIFS=" " Circular Reference Error"
Hello, I figured out how to make work a large formula for =Sumifs. The idea was to add the "target budget" of all projects that would have as Project Manager (PM/RI) "Mari M." and only for the projects that would have an "Status of Request" of ( New, Work in Progress, In Design, In construction, Substantially completed,…
-
Multiple Installation Dates to show on Calendar
Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have Part A Date, Duration and a installer. Same with Part B. The Installer is conditional formatted as a colour to show up in…
-
Multiple Check Boxes in Cross-Referenced IF Statement
I have a master spreadsheet that details the progress of a project. I'm in the process of rolling all the information on that sheet into another that consolidates anywhere from 1-100 lines (check boxes) into a single line. The example below shows an example of 3 check boxes. That being said, I'm creating a formula for a…
-
Excel Converstion to Smartsheets
Does anyone know if there is a way to smart-sync Excel documents into Smartsheet? For example, I have an Excel file that I dump into a Smartsheet schedule each day. But I am running into the tediousness of having to personally sort the file to make sure I am not duplicating information, and then copy-pasting all physically…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Smartsheet "Viewership" Access being denied!
Is anyone else experiencing a Smartsheet wide, all Workspace issue where unless your viewership is "Admin or Owner" you are unable to access sheets that you supposedly have access to? I've noticed the glitch "Fix" itself if I change someone's permissions from Viewer or editor to Admin, then put it back to their original…
-
Linking & Formulas
I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to each of those projects. I have 1 master smartsheet which houses meeting information,…
