Finance
Discussion List
-
Apostrophe added on mass insert thru CDATAIn API & DevelopersHello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an a…
-
Formula for Actual duration excluding duplicationIn Formulas and FunctionsHi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous…
-
Total Cost Based on Date of Task Being FinishedIn Formulas and FunctionsI am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily acc…
-
How to write below formula in smartsheetIn Formulas and FunctionsHi . Can anyone help how to write below formula in SmartsheetAnswered - Pending Review 31 views 7 comments 0 points Most recent by Finops C'ship Formulas and Functions
-
Smartsheet dashboard viewIn Formulas and FunctionsHi Team, Can anyone suggest me how to create this kind of view in smartsheet.Answered - Pending Review 11 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
COUNTIFS between dates & criteria.In Formulas and FunctionsGreetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: …
-
Filtering on dashboards?In Formulas and FunctionsI'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…
-
Has anyone used smart sheet to reconcile general ledger accounts to the subledger?In Formulas and FunctionsWanting to see if we took a report from our purchasing system and uploaded it to a Smartsheet, if it could compare to another sheet that is uploaded from a report from the finance system. I have looked through templates and template sets …Answered - Pending Review 21 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
-
Developer needed....In API & DevelopersI'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.
