-
workflow how to change more than one cell value
Hi all, I would like to change the calue of three cells if a checkbox is activated, but the smartsheet workflow only supports "change cell value" for one cell. Is there a workaround or solution for this? Thank you, Joachim
-
Tracking monthly reports received
Hi, I wonder if anyone can help me. I have a sheet where I track whether clients have submitted their monthly report each month. At the moment, I clear all the results at the end of each month and start tracking again at the beginning of the month. I also want to keep a historic record of whether they have submitted…
-
Gantt Chart Displaying Improperly in a Dashboard
Good morning. I have created a report that shows a Gantt Chart and I changed the settings to start in February an on the current day. I have also filtered the report to only display projects that are In Progress or Not Started. However, when I pull the report into a Dashboard, it see a beginning start date on the Gantt…
-
Simple multiplication in a formula
Hi there, I am writing an INDEX(MATCH()) situation to pull a price, and i want to then multiply it by 1000. It keeps giving me an error due to the *1000. How do I get this fixed? The formula i have is below to pull the price per each. The second formula is what i have to get it to the correct amount, which gives me an…
-
Resource Allocation Filter
I''ve created a new view for my resource allocation. I have a few projects that have resource view enabled. However I only want to look at 2 of my project to see the allocation. When I select the two project in the filter, I notice that my list or resources is by far smaller than if I looked at all project. However upon…
-
Prepopulate form
Hello anyone, I'm working on this form. Please i need some help. I created a form and i want to prepopulate some field before sending it out to the customers. I have attached a picture for you to see. I want to able to prepopulate. products, facility and TD (contact) then file number rows before sending out the form.…
-
Customer now has own Smartsheet account - how to move users from ours to theirs & Sharing workspaces
A customer of ours has purchased their own Smartsheet account. Our account has 1 paid license and ~40 free licenses. All of these individuals are part of groups allowing them access to selected sheets, reports and dashboards. We need to transfer these users to the customer's account while retaining their access to the…
-
Anybody else getting all notifications twice?
All the notifications being sent to me from automation@app.smartsheet.com are being sent two times simultaneously:
-
Template set with URL Links not working
I have a project plan with 3 supporting worksheets. I want to launch the supporting worksheet FORM within my project plan. So, I copied the supporting sheets FORM URL into the attachment cell on the appropriate row for each corresponding support sheet. So far, so good. Then, I did a "Save As" using the option to have all…
-
Create date-based alert with more than 1 date field
Hello, I need to create date-based alert with 2 date-fields - alert when a project is 2 weeks before either "Requested Date" or "Actual Planning Date". However it seems the trigger setup only limits to one date field to select - is there any suggestion for how to solve this? PS: I'm currently creating 2 alerts, one per…