Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
Hi all, I have set up the first draft for an approval flow to draw up credit notes. At the moment I have a flow set up as test that works very well for 1 condition - but I need to have a flow that includes 3 conditions: - credit note approval request between 1-50 euro goes to person A - credit note approval request between…
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on: 1.) One of our…
is it possible to include a PDF file as attachement in a Web Form? It is necessary to review that document and after fill the web form aout and submit it. I am triying to save time and efort for me and the users. Thank you. RP
I need to have current user view works on a dashboard report widget. May I know if it can be done by Dynamic View? I need to restrict user's view on the dashboard depending on who the user is and not sure if Dynamic View is a solution or not. Thank you!
I am working on a budget tracking sheet where I have a forecast column. The forecast column is dependent on if there is a value in an estimated cost column or actual cost column. If there is no value in the actual cost column, then the forecast column is equal to the value in the estimated cost column. If value exists in…
I have input a formula to calculate a monthly revenue figure for an annual subscription charge (i.e. divide the subscription charge by 12 between the dates 01/10/2018 - 30/09/2019. I used an =IF(AND...) formula however it is only picking up Oct - Dec of every year rather than Oct 2018 - Sept 2019. I can't figure out what…
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process. To be able to produce the PDF, I use Smartsheet Merge. But I ran into an issue of confidentiality. Since the form is a finance thing, we don't want the users to see how much funds are requested for each items. Yet…
Hi. I'm trying to build a report that will tell me when we are close to sending bills for a district to the print shop. The criteria is looking at two rows with different names in the Primary Column; i.e. Request Information and Original Proof Signoff but I need different criteria for each when it comes to dates. For…