-
Auto-mapping email correspondence from Outlook back into Smartsheet?
Is there a way to automatically tie email correspondence (happening outside of Smartsheet) for a project back into an active sheet (and possibly the specific project's row)? When we're collecting information for a project and there is external email correspondence happening, while we have a creative brief template that,…
-
Possible for change cell value automation to append text to itself?
Confirm please if this is possible or as I suspect, not. Would it be possible in automation to change the content of a text cell from say: Some Name to Some Name - Cancelled The challenge is that I need the old value to be referenced during the update. Any potential hacks around this?
-
PMO TEMPLATE SET, when I copy the project plan the target dates do not update
Whenever I add a new project, I copy the project template and in the intake sheet I enter the target start and end dates. After linking everything per the instructions and I enter into the project plan the target start and end dates update in row 1 but, all of the tasks have dates from back in the year 2020 so my project…
-
WEEKNUMBER FORMULA
@Andrée Starå That's the formula I'm actually using: =IF(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), "not available ", "available ") i used this formula to check the employees' availability for the current week, the problem is that i have a start date and an end date for each specific work, using this formula I'm able…
-
Cross Sheet References
I need to have 2 columns update on a sheet to match when those same columns change on another (master) sheet. Is there a way to set that up without linking each individual cell? Those 2 columns are constantly adding new rows as new rows are added to the master sheet; I've set up those rows to copy from the master sheet via…
-
WEEKNUMBER FORMULA
That's the formula I'm actually using: =IF(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), "not available ", "available ") i used this formula to check the employees' availability for the current week, the problem is that i have a start date and an end date for each specific work, using this formula I'm able to insert…
-
App - Embed Report Issue
Hello, I am trying to organize important information for a number of employees. I was trying to create a report that only allowed for non license users to log in and see only their information, however when putting reports in a dashboard, it is only set to grid view, where 2 of my reports I would like to be in Calendar and…
-
How can I notify staff when an assignment in a contact column changes?
I have a sheet set up with a contact column so I can assign staff to a request. This assignment is automatically triggered based on request type. When the staff are assigned to the new row, I set up an automation to notify them via email of the request. This is working well. However, sometimes the assignment is changed…
-
Is there a way to prevent Free Licensed users from Sorting rows?
I have sheet that uses a system column to create unique ID for each row - wee need to keep this column sorted in the order that is created. However, with over 120 (over 100 are free license) users on the sheet, many use the sort (based on their excel experience) on other various columns. This causes problems when someone…
-
Microsoft Teams- Smartsheet needs admin approval
So I have added the app to my Teams Windows client. When I go to add a smartsheet to a team, I get prompted with Smartsheet needs admin approval. I am the "Team" owner as well as an Org Admin since I am the Teams administrator. Permissions from TAC show that we Allow all apps and when I search under Manage apps, Smartsheet…
