How do I do A formula that will
If Date Poles Completed is a date then Completion Column will Read "Completed" and if Date of Poles Completed is blank then A will also be blank
Completion is "Completed" then Invoice Status becomes "To Be invoiced"
You only need a basic IF statement for this.
=IF([Date Poles Completed]@row <> "", "Completed")
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
I am trying to calculate two fields in SmartSheet (a dollar amount by a tax percentage in decimal format). I then would like to divide the calculation in half. For example, I would like my hotel rate $109 times the tax rate of 12% to be multiplied together to get the total hotel rate and then divide that total rate in…
This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred. The formula will be on a separate sheet used for dashboard metrics. Is it =COUNTIF(Sheet reference), HAS(@cell)) I know…
©2024. All Rights Reserved Smartsheet Inc.