-
I'm trying to create a tracking system using two sheets.
One sheet is the Gift Card Quantities has the number of existing gift cards in each dollar amount and the other is a tracker that allows the user to enter the gift card used, dollar amount, quantity of gift cards. What I want to do is if a $50 dollar gift card is used, then that number is subtracted from the existing…
-
Automation adding contacts to a sheet from another (not dropdown)
For each project, we have a 'team list' sheet that shows up on the project dashboard. The team list uses cell links from our master employee list, so by entering the name, it automatically shows their phone number, department, etc. In theory, it should be updated at project kickoff and periodically throughout. It never…
-
Is there a way to populate the successors names in a cell based on successors column?
Hi there, I am working with a sheet that includes a predecessors column. I have also created a successors column that lists the successors. I need to display the names of the dependent initiatives in another column. Currently, I am using the following formula, which works only when there is a single successor: Dependent…
-
Health column formula troubleshooting
I want my health column to show as gray for any complete item, green for anything with an end date more than 5 days out, yellow for anything due in 5 or less days, and red for anything past due. It's very close to working, but I cannot figure out why some of these lines are showing gray, when they should be green (such as…
-
Quarterly Results
I'm still fairly new to using Smarthseet formulas. Although the idea is simple enough, I've tried to use COUNTIFS, based on some examples I've found on here that looked similar, but cannot get it to do what I want. My end goal is to create a Smartsheet to display quarterly results that includes the Assigned PM and the…
-
Retrieving data from identical rows
Hello again, I have created this worksheet: Using [ID#] and [Created Date] as reference, how do I display each value under [Entry 01:Entry 03] to fill in under each of the concerned rows? Expected output: Any help will be greatly appreciated.
-
Filter distinct values only into new column
Hello! I have a column that consists of rows with values, some that differ and some that repeat [(Cells Linked from TE Tracker)], I want the next column over "Distinct" to only give me the unique values of [(Cells Linked from TE Tracker)] From what I've seen, there is no direct function that can do this, but has anyone…
-
How do I find the closest matching row that is above my searching row?
I am trying to find the closest matching row that is above my searching row. If Smartsheet does not allow searching backwards (above the current row) is there a way to search downwards, where the closest matching criteria to the searching row is displayed like the formula below is attempting to do? The following provides…
-
Confirmation of sub-task completion
I have set up a Engineering Change Management System in Smartsheet with Level 2 sub-tasks, assigned to resourcers. Most of the resourcers have read only access. Is there a way they can check a check box to confirm completion of their sub-task?
-
Need help with sheet reference formula to grab assigned user for a specific day.
I am working on some cross sheet data and sharing and would like to list in a cell of a sheet the user [Technician] assigned to a space [Bldg-Room] on Thursday from another sheet. There is a column for each day of the week on the sheet being referenced. [Thursday] I can use this formula within the current sheet but I seem…