You can use formulas in a Symbols column. To do this, use the text values of the symbols. For example, to manipulate the value in a Symbols column that uses Status symbols, you might create a formula similar to the following: =IF([Percent Complete]5 = 1, "Full", "Empty")) This l...
The Smartsheet API returns all dates and times in UTC and formatted for ISO-8601, YYYY-MM-DDTHH:MM:SSZ. If you specify a date and time, you should also send that information in ISO-8601 format. If a date/time needs to be displayed to an end-user in their local time zone, you must...
Use TODAY in a formula or a date column to return today's date, or use it in other column types as part of a formula that evaluates dates and produces other output types, such as symbols or text values. Learn more TOTALFLOATLogic New! 02/14/22 TOTALFLOAT(Value) Use this formula ...
When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time.Try Smartsheet for free, today.
For example, Harvey balls, stars, and signal bars. *With boolean symbols (flag, star, and checkbox) write the formula in a text field, then change the field property to the symbol you want to use. Sheet summary limits The sheet summary supports: Up to 200 fields (does not count ...
For example, if you have two sheets, Sheet1 and Sheet2, you could bring Sheet2 data into Sheet1. If you wanted cell A1 in Sheet1 to equal the A1 in Sheet2, you’d enter this formula into A1: “=Sheet2!A1”. The exclamation mark calls on the previous sheet referenced before ...
and used by a variety of different sorts of users. It’s especially useful if you expect to have large numbers of collaborators, both inside your organization and out. Its litany of mathematical formulae is not as robust as Excel, for example, so don’t use it for truly complex calculatio...
Symbols*Collections of visual icons. For example, Harvey balls, stars, and signal bars. *With boolean symbols (flag, star, and checkbox) write the formula in a text field, then change the field property to the symbol you want to use. ...