-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Can I use a formula in a checkbox cell to auto check and also be able to manually check the box.
I am using empty checkboxes to show a task needs to be done. Only certain rows will require this task. So I wrote a formula to auto check any box that will not need to be done. That way a report will only tell me empty checkboxes. Problem is, I need the users to be able to check those boxes when they are done with the…
-
Having two currencies in one sheet
I currently manage vendors in Japan but need to also have currency in dollar for our finance/accounting in the US. I think the only current option is to change the whole account setting to change the currency, but that will prevent me from having two currencies, and will also change the entire setting to Japanese. Is there…
-
What formula to use in Status column based on % Complete column?
Hi, I'm stumped...I've tried this formula multiple different ways and nothing seems to work. Status column: Not Started, In Progress, or Complete % Complete column: any number (column is set to %'s) This is what I need: IF % Complete = 0, Status=Not Started, IF % Complete is greater than 0 and less than 100, Status=In…
-
I am writing a column formula and get invalid operation error
I am using this formula to calculate % of task time but get invalid operation error. Task time is the amount of time spent doing a particular task divided by the shift hours (9) =[Total Task Time]@row / 9
-
Need IF Statement to return first two digits when first digit is 0
Hello, I need a formula that will return a city name based on the first two digits of a four-digit code. However, it comes back with a #INVALID COLUMN VALUE error if the first digit is a 0. For example: 01 = Louisville, 02 = Tampa, 03 = San Antonio, etc. If the number starts with 1, such as 10, the formula works fine but I…
-
How do i create a formula to source information from another sheet with multiple countifs?
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example: The metric sheet is trying to count KPI's from other sheets, for this particular instance a…
-
Index Match (?) to two different sheets (unique values)
Hi - I am not sure what is the correct formula to use - I have tried a few and I get errors, so would appreciate some assistance. I have been using Cell Linking to pull in the data, but due to the volume it has become cumbersome and unreliable. I have a master project plan with unique Site IDs in the primary column, and…
-
Copy the value in a cell to another cell - Dates
I have two columns in a sheet where I want to same date in both columns. I want to link the second column to the first column so that whatever date I put in that first column reflects the change in the second column. I understand this isn't possible with automation at this time as I don't want to date stamp it. How would I…
-
Requesting assistance with multipart COUNTIFS formula
Hi all, My team and I currently use Smartsheet to track monthly referral information. At the beginning of each month, we are looking to obtain the number of referrals received for the prior month (ex: because it is January, we want to capture data from December). Here is what we are trying to track: How many "SEN"…
