-
Predecessor formula Help
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all…
-
Allowing multiple contacts per cell leads card view is removed.
Card view is removed automatically when changing configuration of a contacts type column to multiple contacts per cell. I need that card view.
-
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?