-
Formula to bring back value of a cell based on month
Hello! I need help figuring out a formula and possibly on how to set up a helper sheet to get the formula to work: I currently have a capacity plan for our team. My leaders would like a widget on the dashboard that will just show the team members' names and their allocation for the current month. So I need help figured out…
-
how to change a cell value when a new row is added
Hi I am trying to use a workflow that changes the value in a cell when a new row is added. This cell is already on a row in the sheet when the new row is added. I have hit a road block as when I set the trigger for when rows are added it does not change the value in the cell so I am guessing the workflow only runs on that…
-
Customize Option in Row Send?
Hi there! I'm testing out the row send feature. This page says there's a "customize" option, but I don't see it. I see the "layout" option when one row is selecting. What am I missing? At the end of the day, I'd like to know if there's a way to suppress the name of the sheet in the email that sends using this feature.…
-
Adding attachments to a row with 2 forms
Is there any way a row with files in the attachments can be merged with a new form entry that also has an attachment. Currently I am using formulas to join the original row with the new form data but since forms cant add to existing row I cant figure out how to have both attachments on the single row. Is there any way to…
-
Formula to pair staff based on criteria
Hello Smartsheet community, An idea came up recently about pairing staff up who work in different divisions for a random coffee chat to increase staff engagement. We could use Smartsheet to create a form to gather info on staff who are interested in participating and what division they belong in but is there a formula I…
-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
How to create webhook for sheet as third party?
Hi Smartsheet Community, Our startup has fairly simple use case to update our backend systems when a third party Smartsheet document is updated that we have view access to. Based on our research, I understand that as a third party, the only way to receive webhook notification updates is by using a Smartsheet WorkApp which…
-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Can I update a cell date in one sheet and have another sheet also update to the same date?
Hi, I'm very new to using Smartsheet. We have two different smartsheets with the same project in both. I'd like to update a date in the date column and have it automatically update in the other smartsheet. is there a way to do this? if so, could you please provide a step-by-step for a fellow new user? Cheers, thank you!
-
Alert when tasks are planned to finish after a date in another task (deadline)
Hello all! I am trying to program a sheet to alert users when any finish date in the sheet goes beyond a specific deadline task in the sheet. I foresee it working like: User changes a start date, and several tasks down the dependency waterfall, a finish date gets pushed beyond the deadline task's date, and an error shows…