-
Merged: One Form - Multiple Row Entries
This discussion has been merged.
-
Workflow Question
I created a workflow to populate a field when a flag is set to on. I want the field to populate with text, and the current date. Is there a way to add the date to the field? Thank you
-
Smartsheet Bridge
Hi, I'm on Enterprise Plan and I'm trying to use Bridge but cannot log in to it. I actually had to dig the login link from the forums because I could not find it anywhere else, and when I try to sign in using my Smartsheet account it says "Unable to log in with Smartsheet credentials at this time, try using Bridge…
-
Weird issue with copy row workflow
I'm having an issue with data formats in a copy row workflow. I have a sheet that is functioning as a form. There is a list of data spread across rows and columns, and different people are updating a value in a single column. When that value is updated, the row is sent using a copy workflow to another sheet. On that row it…
-
Smartsheet Automated Workflows - When anything is added or changed - Weekly Report
Hello, My team has a Smartsheet that is very column heavy due to the nature of the sheet. We would like to send out a automated sheet summary to stakeholders that contain any changes or additions highlighted weekly. The problem we are running into is that it looks like the email notification report contains all rows that…
-
Need more than 150 Workflows on a form
I just hit the 150 Workflow limit on a sheet I'm making. This sheet connects to a form which, to be successful, depends on the Workflows. The set up is that users select from dropdowns on a form, which triggers a Workflow to add a new line to the sheet with text from dependent on what dropdown was selected. There are many,…
-
Workflow to copy a cell and paste its value in another cell when the first changes.
Hello everybody I'd like create a workflow to copy the value of a cell date type when it changes to another cell in the same sheet. I can trigger the workflow when there's a change, however I can find a way to bring this value to the other column without using DataMesh or Formulas. In my case I want to avoid to use these…
-
Using a form to create child tasks
I've read in several places that this isn't possible but I keep getting so close I don't want to give up. The need is straightforward. When a form is submitted add a number of child tasks to the entry. Here's what I've tried Create a template sheet and use VLOOKUP or INDEX to update the the parent task, then trigger a…
-
How to guide a stakeholder through a multi-step monthly review process?
We are managing a portfolio of projects that cut across multiple teams. Each team has a "spokesperson" that is responsible for completing a handful of reviews each month for portfolio governance, such as: Review report showing project milestones that they own Review report showing project milestones that are owned by other…
-
Can anyone please explain why my Mid formula is not working?
I am trying to pull the 5 digit number ID in the middle of this text string. My formula works for the ones labled CTV however for everything else it is an #Incorrect Argument. Any help would be greatly appreciated =IFERROR(MID([Campaign Name]@row, FIND("_CTV", [Campaign Name]@row) - 5, 5), MID([Campaign Name]@row,…