We have lots of alerts/actions/notification rules setup across lots of sheets. When I delete a user due to employee termination, then I get this message:
"Invalid recipients in Alerts and Actions rule"
I don't want to have to dig through dozens of sheets to remove the people, how can I do this on a
Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give
Hi there Smartsheet community,
I don't know if anyone can help me?
I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time.
Column A- Start date (20/06/2018)
Column B - End date (31/05/2018)
Column C - 20 days
I am working on a sheet that will store files sent by third parties.
But currently It does not give me the option to place a field to ask for attachments on the form I am working on.
I started to use Smartsheet recently, so it can be quite easily to solve this problem, so please be
I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay,
I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week.
I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months.
I am pretty sure each cost would
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column.
I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the