-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
How to set-up net-30 days in Smartsheet
Although seems very elementary to set this up, however, I am having the toughest time trying to build this "net-30" into our invoicing report. Can someone help me out? Thanks in advance!
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Promoting Smartsheet
How much does anyone else promote this program. Have you heard the words"are these guys paying you". I just completed a mastermind group and it was a dominate topic for me in addressing how business owners can advance their company. I am wondering what is the level that all of us on here feel and promote about this…
-
Rolling Up or Consolidating Divisional Budgets
Fairly new user here. Looking for help in rolling up our divisional budgets into a consolidated budget. I have an income statement budget template for each division which has worked beautifully with callaboraters completing their info. These templates (sheets) are all exactly the same format. I'd like to have a…
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
-
Engineer's timesheet
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
-
How can I add rows from one sheet to another automatically?
I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO. So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice…
