-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
-
Avoiding double entry in multiple sheets.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
-
Count Dates
Hello, I have a date column. I need to be able to count the number of dates in the column. Is there any way to do that without having to create another column using checkboxes? It would be nice if Smartsheet supported the COUNTA function. Thanks!
-
Percent Complete inconsistent in population
My sheet is very odd looking right now. I've assigned % Complete to the % Complete collumn. My results however are not all presenting uniformly. Some are rolling up as %, some as 0.xxxx and I can't figure the reason. I understand they represent the same thing, but formatting matters for some of my stake holders.. It's…
-
Can you add a VAT field in a smartsheet?
I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible? I have tried to add a formula e.g =SUM(amount)*20% and also +=SUM(amount)*0.2 Neither of these work - it just shows an error message.
-
Calculating age in months
I'm testing smartsheet to see if it can do better than the current excel spreadsheet that is becoming unwieldly with too many users. Basically I'm replicating the current structure I have in excel which tracks recommendations made, responses to those recommendations, and implementation dates. I need to track when…
-
Recurrent reminders
Why after i put the actual date on a task before the "planned date",it keeps sending me the reminder for this task although i already did it. Also ,why after pluging an"actual start date " it doesnt update the all other dates including the end date Thanks
-
How do I append a text description to a formula
I have an fx: =“Task - “ + COUNT(children()) How do I append 'text' to this formula?
-
Automatically populate a "STATUS" column with 1 of 5 values
I am looking to automatically populate a "STATUS" column with 1 of 5 values based on critera/conditions are outlined below. The key drivers here are the - [% Complete] - [Start] Date - [F/C Finish] Date - this is a column I have set up that uses a formula to predict a Forecast Finish ([F/C Finish] = (Today() + (R x D))…
-
formula help with symbols added
I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission…
