-
Error when adding index linked formula
Am getting attached error even though all data is pulling into the sheet correctly, I have info pulling in from 2 x separate sheets. Can anyone confirm if this is impacting data or just an error I can ignore? Thanks
-
#Invalid Operation when determining whether date is in the past
I am working on answering someone else's question, and have come across an issue. I am perplexed! Can you please help me? The formula is to determine whether the planned end date is in the past. If it is, it's to show "Overdue"; if it's not, it's to show "Current." (There will be much more to this formula later, but I'm…
-
Cross Sheet Formula - Count how many times a date appears within a date range
Good morning, We have a log sheet that is constantly building on itself for when we communicate with a client. We call it a "touch." I am trying to count how many times we have had a touch per week of the year. I thought this would be simple, but for some reason I am struggling to make this work for me. Hopefully the…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
Date Calculations
Hi there, I am trying to do a simple formula for a date to automatically populate in the Date Due column. I take the Event date and subtract the number of days prior to the meeting for each individual due date. This is the formula I created. However, when I run this formula in the Date Due column, nothing is returned. What…
-
Determine how many projects are active during given period
Hi all, I was wondering if anyone can help? I've got quite a number of projects running from Timepoint A to Timepoint B (several months) and wondered if it was possible to write a formula in my (separate or the same sheet) metrics sheet to determine how many projects are active during given month? For instance, I have 5…
-
Index/collect/join-match formula when source sheet row meets multiple criteria
Hello! I'd like to apologise beforehand, but my brain is fried at this point. I do believe it's something easy and I did go through similar entries on this forum prior to posting this. I'd like to have a cross-sheet formula where, once certain criteria of cell values are met in the source sheet, it will update my date.…
-
Determining "In Stock" From an Inventory Library by Matching SKU
I have two sheets: Inventory Library and an Order To-Do List. I want to be able to check a box marked "In Stock" if the Inventory Library shows that the matching SKU has more than 0 in stock. I am trying to use an Index and Match Function to return the actual stock number in the Order sheet and then format the checkbox to…
-
Add the emails as hyperlinks - get it recognized by contact list
Hi All, is this function supported: =Alias@row&"@email.com" - in the 'Alias' column I have logins & I would like to add to this aliases in another column also the domain: "@email.com" so they get recognized by the contact list. Thanks - Viktor
-
I need a formula to clear contents in a field if the date in another cell is in the past.
For our process documentation review cycle, we have a column for Date of Next Review. There is a column next to it, Reviewed Process, that has a dropdown to indicate if the document has been uploaded to our Sharepoint site. If the date of next review is in the past, I need the contents in the Reviewed Process column to…