-
Auto Reference one sheet to another
Hello all! I am trying to create a sheet that will auto update based off it's master sheet. I know that I can Link cell in other sheets but it only allows me to do 50 cells. Is there a way to link more than 50 cells or the entire sheet?
-
Formula address to google maps
Hello I am having trouble finding this post. I remember seeing a post with a formula that automatically creates a link to google maps with an address pulled from a column. Address is typed in column by street then Alt enter then city, state, zip. I have looked high and low for the post but can't find it. Does anyone know a…
-
Combine: IF AND CONTAINS, And SUMIF
Hi, I got a question about how to use all the above statements in one formula, _______ I have the following columns; A regular text column "Client ID", A multiple dropdown column "Shared IDs", A regular text column "Hours worked" A regular text column "Shared Hours Approved" _______ I have each client and their Client ID…
-
Formula changes without showing in Activity Log?
I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1:Location@row, Location@row, Year$1:Year@row, Year@row)) It basically creates a custom identifier that uses the year and a…
-
Multiple IFs in If Statement
Hi there - I'm creating a simple task tracking sheet, but having trouble formulating the correct formula. I have a TASK, ASSIGNED DATE, and a DUE DATE. I would like the due date to be dependent on the task at hand - a survey would be due 2 days after assigned, permit comments are due 3 days after, and so on (I have 5 tasks…
-
Using dates in a formula for text/number columns
I have text/number columns that represent weeks in a project timeline template. I want to be able to keep the column names generic (Week 1, Week 2, etc) and have the Monday date of each week in Row 1. Projects last months to over a year, so manually typing these dates in is tedious. The ideal scenario would be to put in…
-
Counting blank values in one cell but only if a non blank value exists in another cell
Good afternoon, I'm trying to create a sheet summary formula that counts the number of blank values for a cell, but only if there's an entry in the sheet because my original sheet summary was counting blank values when there wasn't an entry in the sheet. I've reviewed several posts and tried a couple of different formulas…
-
Auto populate End date based on the start date.
Hello all, Need some help in auto populating the end date based on the start date mentioned in the smart sheet form, is this possible? If the start date is today then the end date should be 30 days out. Thanks, Karthik
-
Inventory tracking: link items to dates and locking them out during already selected time frames.
Inventory tracking: if an item is selected in 1 column and there are check-in and check-out dates in their own separate columns, I would like the availability column linked to that item, and if the item is already booked for a date or date range that someone else is not able to select said item if any of the dates overlap.…
-
I keep getting #UNPARSEABLE when I use this formula. What am I doing wrong?
Here's the formula: COUNTIFS(Successors:Successors, HAS(@cell, Rownum@row), [% Complete]:[% Complete], OR(ISBLANK(@cell), @cell < 1)) = 0