-
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…
-
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…
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…