-
Post-Award Management in Higher Education
Hi, I'm brand new to Smartsheet and would like to know how people use it for post-award contracts & grants management. Thanks, Amy
-
CountIf And
I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet. =COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 Auditor Name}, "Brian"))
-
Request updates from team members via Slack Direct Messages
It would be nice if I could push a request for update to a team member directly to them in a Slack Direct Message rather than in a group Slack Channel. For example, if I want Team Member A to change the Status on their task or add a comment, it would be cool if that request went directly from Smartsheet into a direct…
-
Overlapping Two Charts
Hi all, I have a column chart showing our actual hires and I was hoping to see if there is functionality to include a line graph on top of that to show the targets we had per month (see example below). If not, I'd be open to suggestions on the best way to display this. Thanks!
-
Worklflow Requesting Information be Added
I would like to send an automatic email to a designated person to provide additional information to the list. I am basically asking them to assign a specific study number to the request sent. How can the workflow be clear with easy access back to the list to populate the requested information?
-
How to pull earliest start date based on condition
I am trying to create a conditional formula that will pull the earliest start date (listed on a separate sheet) based on a criteria which in this case is the room number. Currently, these dates are tied to the resource manager in the reference sheet and are manually inputted into this summary sheet I have tried using the…
-
identify sheets that an email address has viewing access to and remove them
I see in my "User type report" that I have an email address of an old client with viewing access of 1 sheet. How do I find the sheet they have viewing access of and remove them? They were never a licensed user, but had been given viewing access to a sheet long ago. We have hundreds of sheets so need to determine which…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Hyperlinks / Update Requests
Hello, I currently have a workflow in place with a update request being send out with helpful hyperlinks with instructions for my users to view prior to checking off and item as complete. The issue is the hyperlink only works within outlook, the hyperlink functionally goes away when the user clicks on "open update request"…
-
IFERROR function question
=IFERROR(INDEX($O$19:$O$46, MATCH($A9,$N$19:$N$46,0)), "") My table ranges point to the correct cell lists (verified by the color-coding), but I do not get the correct output. I get the whole formula written in the cell as shown above, instead of the value in the table cell corresponding to the A column pulldown…