-
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…
-
Date over 30 days = "text" formula help
I have a column where a date will be entered. Based on that date in another column, I want to state "Pending" if the date is over 30 days past the original entry date. =IF([DeliveryDate]@row > TODAY(+30), "Pending") I'm not getting errors with this, however, the text "Pending" is not displaying when the DeliveryDate is…
-
COUNTIF (Counting a column based on other column Information)
Using 2 columns (Status) & (Tracking) I'm trying to count the amount of "complete" status in the Status column where the Tracking column is not Past Due. Below is the formula I created. =COUNTIF(AND(Tracking:Tracking, <>"Past Due", Status:Status, "Complete")) It's not taking the formula, any thoughts? Bonus Question* ***…
-
Is this even possible?
I have a process document with columns with start dates and due dates. The process steps do not change from year to year. What I would like to do is trigger some action or create a formula that once an item is checked complete, the start date and due dates advance by 365 days. It would be great if the complete box was then…