-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
Sumifs That Excludes Parents
Hello, I am working on an ever expanding project timeline that has 100's of parent tasks that flow into potentially up to 10+ levels of parent tasks, with children tasks at every level. Given the granularity of the task management and the timeline being outwardly facing, "=sum(children())" is used on every parent task to…
-
Attachment in an online Form
Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how? I guess it is possible as this form I am filling in has this feature. Thanks you for your help Ugo Quaglino
-
Merged: Please Remove Cross-Sheet Reference Limit
This discussion has been merged.
-
Progress billing/invoicing
our company is in the process of integrating to the Smartsheet platform and will have several of the upgraded platforms including Resource Management, Data Shuttle. The only issue that we are having is that Smartsheet cant create the progress billing/invoicing that our company needs. Below is what we are currently doing in…
-
I have a single cell I want to auto-add the sum
I have a cell that is for quantity of material used. Say I put in 3000. Tomorrow I want to put 2000, instead of manually adding it together to get 5000, how can I make that cell auto-add to get 5000 and not have to add it manually together.
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
-
COUNTIFS between dates & criteria.
Greetings 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: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
How to recreate a payment month Excel formula in Smartsheet
Hoping you might be able to help me with migrating a formula from Excel into Smartsheet. I'm in the process of recreating a payment tracker solution for some colleagues of mine, but I'm struggling to replicate one of the formulas. The formula is as follows: =IF(DAY(C4)<=3,TEXT(C4,"yy-mm(mmm)"),TEXT(C4+30,"yy-mm(mmm)")) The…