-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
Formula to determine the date that another cell was updated
Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Completed", TODAY()) Thanks for your help! Andrea
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
Automatically set a date based on a checkbox
I want to be able to automatically set a due date of the next day based on a 2 criteria 1) a check box is checked, and 2) a cell having text in it. For example (we do cabinet installations)...A check box for "repair doors needed" is checked, AND "Repair door sizes to order" cell has text in it. When those 2 criteria are…
-
Getting status of a RYG with a Date Column
Greetings, Thank you for taking the time to read this. I am a newbie to both programming functions and to Smartsheet. I am working on a sheet where I require to report out the RYG Balls on the end of calendar months. I have two columns I need to create a function for- "Date of Update" and "Status Report." When the Status…
-
COUNTIF CHILD AND UNRESOLVED
I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether the comment is resolved. I am trying to create a formula to calculate the number of unresolved comments per agency in each…
-
Count specific total number grand children rows and ignore higher rows
Hello All, I am tracking different sessions being hosted between employees. The sessions are the rows with the white background. I want to dynamically count the total number of sessions that are happening for row 2 "IMC". So I need to count the number of children of row 3 "IMC Common Architecture" as well as the number of…
-
Translating Date Formats
We have Smartsheet integrated with another system and pulling data across into Smartsheet. Currently the date format that is coming across is (YYYY-MM-DD) and I want to translate that into my local profile date format of (MM/DD/YY). Is there a function or formula that allows me to do this? I have been unsuccessful in my…