-
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?
-
Copying Cell Linking
Is there a way to copy and paste a row and retain its cell links to the pasted row?
-
Extract location data from attachment (picture)
We are using our sheets for sidewalk repairs. An inspector in the field will open the form in the field, on his phone, fill out the basic information (type of work, address). The sheet will auto-populate the date, but I also want it to auto-populate the location. I was thinking if he were to take a photo, both android and…
-
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…