Once someone submits a form, they receive a notification that says their submission was successful. Once the approval flow has happened, if approved how can I have the same submitter receive an approval email....or disapproved if that is the case. Is this possible if the submitter emails is recorded in a column?
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
How do I do this? If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status. Thanks
Hi All, I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being…
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
Dear all, Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred. We are maintaining it in an excel sheet but I am afraid some receivable might be missed. What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive.…
I get an #UNPARESABLE error message for a vlookup I am trying to create to a separate file in SmartSheet, I suspect there is a problem in the syntax. I've tried multiple tweaks to this formula with no success. As a check I exported the SmartSheet and the external file to Excel and had no problem successfully creating a…
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
Dear Community, I am trying to retrieve the information of one cell depending on several criteria: - Match week number from a date with Week Column to retrieve the payment amount - Prioritize between 2 dates (though between 2 week numbers) which one will be retrieved (Actual Payment Week will have priority over Expected…