1

I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month:

=COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY()))

 

Then I

3

Hi,

I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop:

Report Image

You will see on here that there is:

  • 3x for the FASTRACK Workshop
  • 10x

1

Hi,

I have a series of standard processes that have the same dependency and predecessor data each time. 

I have the primary column  as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).

If pre-assembly is selected, for

6

Hi,

I currently have the following formula which is used for counting how many jobs we intend to complete on a day:

=COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY())

This works fine, although there is a scenario where we often add things to the job, which is identified

4

Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait untill it has saved. is it possible to turn this off, and maybe just save it when required, or when you

4

Hi,

I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value.

=SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value})

The sheet references are to single columns titled 'Completion Date'