-
Helper columns to allow parent row data to be included in automation
Hello! I am trying to work on refining our automation in a project management tracker we have. Our parent row has the start and end date for the entire project. I am trying to create a helper column that would automatically count days to end of project for each project and repeat that number for each line of a project to…
-
Is there a way to change info in a master sheet to be reflected in sub sheets?
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
-
Using =SUMIFS and a specific date as criteria to total another column of data
Hello! I am trying to use the =SUMIFS formula to sum up a range of donations that occurred on a specific date. Essentially, I have a giant list of donations, with a column that shows date, and a column that shows the donation total. I'd like to run a formula that will total all donations made on a specific date in that…
-
Update Request - Accumulated hours formula
Hi All, Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form. I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person who will enter the amount hours they spent on the task in the week just gone. I would like…
-
There´s a way to copy a row to another sheet with a if formula?
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column. Is this possible?
-
Counting Contacts in a Cell
I want to count the number of contacts selected in a column. Is there a formula to do this?
-
sheet summary, countifs task status
I have a simple formula, i can't seem to get working. reads - invalid data type In the sheet summary i want it to count the task status, (Red, Yellow, ...so forth) When i put in specific range ie [Task Status]2:[Task Status]100 - it seems to work fine. but when i wish to calculate the entire column. (*some rows may be…
-
Keeping track of your Task IDs
This is not necessarily going to be of any use to you, but I can tell that you're curious... The sheet has an old list of tasks and ID numbers at the bottom - a sorted list above and logic to find matches/duplicates.
-
Send an automated response to the sheet owner email address the moment I receive an alert ....
I share as a viewer for a smartsheet model for which I receive alerts when the model changes. Is it possible to send an automated response to the sheet owner email address the moment I receive an alert that has certain characteristics? The backstory is that my condo association posts available units and the owner that…
-
Nested IF Formula - with drop down list
Hello, I'm trying to figure out how to create a really long IF formula based on options provided in a drop down list. I'm having students select their major from a drop down list. Depending on what major(s) they select, I'd like to auto populate the division that that major is connected to in a different column. For…