-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Is there any option to share some selected columns in the sheet?
Is there any option to share some selected columns in the sheet? and if they update in the shared sheet automatically it should update in the main sheet. is there any process?
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
How do I share specific rows only?
I want the user to see rows that are assigned to them only.
-
Creating project plan by status??
I am trying to create a simple sheet for creative design requests. -Organized by status (new, in progress, complete) -I want to create a form for the marketing team member to fill out. Once filled, it automates into the appropriate columns (brief, start date, end date, etc. -Then when a request is added, I want to automate…
-
Portfolio WorkApps Not Displaying Projects in Project List
So I am working with building out a Portfolio WorkApp for one of my programs that I have built. When I get it all set up, I can see the projects that I have created for the program on the projects list, but when I hit preview to look to see if it's looking the way I need it to based on the roles, none of the projects show…
-
Remove Duration from Project Plan Task Unless Certain Criteria Met
Hi there! I am working on building out a project plan template that we will use for onboarding. There are multiple branching paths and decision points that need to be made throughout the process, which determine if certain steps must be taken. I've managed to set up a way to "deactivate" tasks based on those conditions…
-
Setting Status column based on the number of "IS NOT BLANK" columns
Hello I'm new to Smartsheet and need some help. I'm tracking a project that for each participant, 12 different tasks need to happen to generate a complete data package. There's no set order for the tasks to occur, and there's no set time limit. I want to use the 0/quarter/half/full symbols to track the status of each…
-
Mail merge emails
We keep our customer contacts in SmartSheet now and send some emails to the list via our Outlook accounts. Is there a way to write an email in Outlook (or Word) and merge the email address from Smartsheet without exporting the sheet to Excel? We use Google Docs but not that much.
