-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Metric Sheet Calculations for a Dashboard
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
-
Approval flow for credit notes
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…
-
Filters for Smartsheet Documents
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…
-
Attach a PDF in a Web Form
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
-
Dynamic View: Current User for Dashboard
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!
-
Forecast using if function
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…
-
Formula issue - IF Statement between 2 dates
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…