Finance
Discussion List
-
Local Government UsesIn Using SmartsheetI am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, H…
-
Access Security for FormsIn Using SmartsheetDoes anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two options. * Anyone * Anyone with a Smart…
-
Adding resources costIn Using SmartsheetHi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I could…
-
Incremental Budget Forecasting based on Monthly Due Date PercentagesIn Formulas and FunctionsIn excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For C…
-
changing email address in contact list (web formular)In Formulas and FunctionsHi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a…
-
Automated update request not workingIn Using SmartsheetHi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work. Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in …
-
Formula to check box if cell contains Date OR TextIn Using SmartsheetI have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to tim…
-
Automatically add formula to new row & apply @row to look at row aboveIn Formulas and FunctionsI have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within…
-
SUMIF by Vendor and DateIn Formulas and FunctionsI am new to Smartsheets and cannot figure out the formula for a particular SUMIF. Basically, I need the total by Vendor & Year. I have an incredibly long list of invoices that I've imported into Smartsheets, and want to be able to use …
-
Multiple IF function pull from multiple cellsIn Formulas and FunctionsI am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row. I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected. cu…
