-
Visible audit log instead of "view cell history" for numerous lines of data
I know I can view who marked a check box through view cell history but I'm looking for a way to display the person who marked an "approved" or "Done" check box without all the extra clicks; I need a visible export format as an audit trail. I can't rely on the "modified by" field because we have users that go in after an…
-
How am I using this Formula wrong?
I get a "#INVALID COLUMN VALUE" error from this formula.
-
Here is a tough one - Identify Route Blackouts
I need to schedule work on a particular route. Within my records I have a column named "Route" that shows the route number. EX: 10402. I have a DATE column called "Target". I want to add a column called "B/O Check" and write a formula that will take my target date and route number, look that data up in a sheet called "MW…
-
Exclude cells with no data?
What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for WORKDAY.
-
Multiple cross references for one sheet?
Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in…
-
Is it possible to have a column only be available to be selected based on the status of another?
I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?
-
Formula to return results based on workweek not calendar week
I have this formula =COUNTIFS([EOD received]:[EOD received], "no", [Attendance for]:[Attendance for], (TODAY(-1))) It tells me how many end of day (EOD) emails have not been received by an employee for the previous day. So on Monday I check the attendance for the previous Friday, on Tuesday I check the attendance for…
-
Formula to indicate the duplicate dates
Hi, We had dates for contracts captured in 2 different systems and I want to do a compare of which contracts have conflicting information. My worksheet has the contract number, the "Expiration Date in LR" and "Expiry Date AER", and I just want to compare where the 2 dates are duplicates, to work through the remainder. I'm…
-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Greetings from New Jersey!
Hi Smartsheeters, I am fairly new to Smartsheet. I've been using it since November 2023. Just earned my Core App certification. I'm hoping to increase use of Smartsheet at my company and find ways to automate processes and integrate data from other systems. On the weekends I'm busy doing pottery and riding my ebike.