-
Is there a v lookup type formula that will find all tasks assigned to a specific person?
I am building a personal task tracker template for my team so everyone can better manage daily tasks as well ass see any tasks assigned to them as part of a project. Is there a formula or way to have project tasks automatically added to a sheet or report as they are created and assigned to a specific person?
-
How can I average a percentage in a parent row?
I have a status column that uses Red, Yellow, Green and Gray to represent "Not Complete", "Partially Complete", "Complete" and "Not Applicable". I successfully added a progress column that uses a formula to translate those statuses into a percentage. However, since the parent row also has a status color, I can't get the…
-
#Invalid Data Type
Hello, I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11". Does anyone have any recommendations or see anything wrong…
-
Is Smartsheet experiencing issues with dependencies functionality?
I am currently experiencing issues with dependency functionality. This seems to have started 11/3/22. The functions FS and FF are not working. When FS and FF are leveraged, they extend the dates duration to 2 days vs the 1day duration preset. Are other users experiencing similar issues? Is there an expected resolution on…
-
Scheduling for Resource Availability
Hello, I have a sheet for users to enter requests for our quality department. They chose a type of task they need, i have a VLookup assigning how many hours to assign to that row based on the task. That all works fine. But I need to find away to factor in the staffing restraints for each day and push some tasks out if too…
-
Cell History has disappeared
Hi All, Has anyone experienced a loss of cell history? We have a sheet that previously had cell histories but now says This cell has no history across the entire sheet. Other sheets in the same folder and workspace have not been impacted and continue to show cell history. There doesn't seem to be any obvious changes in the…
-
Which formula to use to set conditional rules between 3 columns in a sheet?
Using formulae in sheets, I am trying to create a template for Stakeholder mapping by embedding the below conditions and results. For Instance If (1) is entered in Column A and (B) is entered in column B, column C should pull in "Keep Informed". Or if (2) is entered in column A and (C) is entered in column B, column C…
-
Need help with an IF Statements with multiple ORs and an AND
Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback AND the COMM Review column has the following: COMM Review Complete If both the Review Column has one of the 3 options AND the COMM…
-
Metric Widget is referencing sheet that has met the 500,000 cell limit - What do I do?
I have a dashboard widget that is referencing a sheet that recently met the 500,000 cell/row limit. I thought breaking out my sheets by year would be enough space, but I was wrong. Is there a way to keep the look and feel of my dashboard widget, but have it reference 2 sheets (or something like that)? Thanks, John Stanik
-
Global contact list
Our company has many logins to use smartsheet, but we want to have the same contact list when adding names to a contact field on smartsheet. For example, when I add a contact to a contact field on a sheet, I can select from a list of contacts that only I have added (see image). If another staff member goes to that sheet,…