-
Whats wrong with this formula?
I'm using this in a metric sheet to count the term in a sheet that has multiple entries per row from a drop down list. It currently produces the error message #INVALID OPERATION. =COUNTIF({PH Roadmap Intake sheet Range 1}, CONTAINS([Primary Column]@row)) I was attempting to copy the one @Paul Newcome provided on 9/8/21 but…
-
Keeping Parent with Children when Filtering
I have a sheet with a list of courses to develop each term. Each row represents a course and modality (online OR blended). In most cases, only one modality is developed for each course. In some situations, we work on both online and blender modalities at the same time. For these courses, I have a parent with some course…
-
Automated Workflow - Recurring Notification based on Date Field
I have a sheet where I need to have a notification sent to a team every 6 months from an entered Start Date. On my sheet, I have the Project Name, the Project Status, and the Project Start Date. It seems in the workflow setup, the only triggers are when a row is added, changed, or when a date is reached. My instinct tells…
-
Free User can't modify Sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? I have a Pro Plan. This is a test user with my personale email that i've invited without a license. With this user i can see the shared…
-
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…
