我f i have a drop down "n Progress" and "Complete" can I do a timestamp in a new column when Complete is selected?
how do I create a Week of Date based on dates during the week? For example the Delivery date of 10/21 I want populate the Week Delivery Date with the week number Date. Do I need to create and additional week number column or is there a formula I can use?
Hi, I need to add a column to my sumifs formula. I need to check if there is a payment in a new columns This is my current formula. =SUMIFS({payment Log Ret Dep}, {Pay Log RETAIN}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2022), {Payment Log PM2}, "Dean Hammel")
We use and install date and those dates change as we go back to jobs. I want to record that first date in another column. is this possible?
我use the formula below to add up work amounts on a weekly basis. rows get moved to another sheet once they are shipped. To keep history I need it to check from both sheets. =SUMIFS({Master JOBV Range 1}, {MASTER SCHEDULE Range 1}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) =…
We are starting to do job costing in Smartsheets. The blue line represents the Parent row where all our KPI s are. They are pulling from the tables below or off of other SS. The tables below populate the blue line and are child rows so that they can collapse. I want to use this one as a template and have the parent/child…
我s there a way to hide an underlying sheet for a report? Our staff has to edit fields but I don't want them to see all the information in the underlying sheet. I created a report but they still go and access the sheet.
Can anyone recommend a 3rd party form to get data into a sheet? I have this attached sheet that our costing department uses. If I were to use SS form it would get too long. Any suggestions?
我'm trying to get totals per week per engineer. I set up a table to get weekly amounts this formula is referencing another sheet. Job Value $, Engineer, Week. I'm not super proficient with formulas so any help would be appreciated Here is the table to get the weekly totals for each engineer
我'm using reports to do "summaries" using Average and Sum. All underlying sheet columns are formatted in US Currency. The Total is displaying the number with the $ sign but no comma. Is there something I'm doing wrong?