-
Highlight Today's Date on a Report
Hello- is there a way to highlight today's date in a report without having to go back to the source pages? I would like to have our Go Live board to have "today's" date highlighted while also having the rest of the dates for the on the report, so it helps our implementations and field team plan.
-
How to sum total meeting hours members of a project will have to attend?
I have a Smartsheet that contains the meeting name, the number of hours the meeting will be conducted, and a contact list of the attendees of each meeting for a project. I would like to create a formula that will sum the total meeting hours each member of the project team will be expected to attend. For example, the…
-
Random assignation
Hi, I'm trying to assign a task to one of my team members (there are four). Every time a new project is added to the queue, instead to manually add one of them, i would like one randomly chosen person among them four. Can you please help me to get this? Thanks in advance! Alberto
-
Getting Max Allowed Cross Ref Error but only 64K cells cross referenced from other sheets
Greetings all, I have a smartsheet with 16K rows. each row has 4 columns that have data referenced from other sheets. That should be a total of 64000 referenced from other sheets. However, I am still getting the "Some cross-sheet formulas can't be updated because this sheet has more cells referenced from other sheets then…
-
Data transfer from one sheet to another once condition met
How information in some columns in Sheet A can be transferred to Sheet B once a specified condition in a specific column in Sheet A has been met? Is there any formula I can use? I used Index(Collect ...), but it doesn't do what I am looking for.
-
Formulas for
Is there a way to change a formula to a static value, once a date (or other item) is entered. ie. So once a formula pulls info it updates the cell. At the end of the month, ( a date is reached) it removes the cell formula, but the info in the cell stays in place.
-
averageif from another sheet
Hi everyone, I have a sheet that is populated from a form. There are several departments listed, and more often than not a department is listed more than once. Within that sheet I have a column listing the response time in days. The response time in days is calculated based on the information within that row. I have…
-
Can someone help me count tasks coming due (using both original & revised due date columns)?
Hello, fellow Community members! I'm new to formulas/equations in smartsheet and could use your help. I'm trying to create a formula that counts how many actions are due in the next 7 days. The tricky bit for me is that there's both an "Actions Planned Due Date (Original)" column and a "Actions Planned Due Date (Revised)"…
-
How to use a formula for SUMIFS with more than 2 not contains criteria?
If I have 3 columns one is "department", the second is "description", and the third is "amount". I would like to sum up the total "amount" for only department-1 in the "department" column, that doesn't contains "ABC" or "EFG" or "JKL" in the description column. I am trying to use =SUMIFS({amount},…
-
Using INDEX/MATCH, but not returning a blank value
Here's what I'm trying to figure out, and hopefully you can assist. I have a form that adds a new row each time it's completed. Not every field is required though. Using a second sheet, and the INDEX / MATCH functions, I have a sheet that shows the most recent entry for each site. But, when a field on the form (and thus…
