-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Help with a formula
I am trying to use the IF formula and I can't figure out where I am going wrong. Thanks in advance I need to subtract the Contract Amt from the budget amount ONLY if Financial responsibility is TI or Make Ready. So if the financial responsibility says Landlord, I don't want the contract amt to be subtracted from the budget…
-
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…
