复制另一列中不起作用的值(在IF函数内) [英] Copy a value from another column not working (within IF Function)
问题描述
当我使用这个公式时:
= IF(ISBLANK([发送日期]),"< img src ='/ _ layouts / images / blank.gif 'onload ="" {"&" var SPday = new Date(); &&;&" SPday.setFullYear("& YEAR( [请求日期])&","& MONTH([Date
Of Request]) - 1&","& DAY([Date of of nbsp; Request])&" ); &&;&" var Days = Math.round((SPday.getTime() - new Date()。getTime())/ 86400000);"&" ; this.parentNode.innerHTML = Math.abs(Days)+'
days'+((Days< 0)?'past':'left');"&"}"" ;>"," = [Days days]")
=IF(ISBLANK([Date Sent]),"<img src='/_layouts/images/blank.gif' onload=""{"&" var SPday=new Date();"&" SPday.setFullYear("&YEAR([Date Of Request])&","&MONTH([Date Of Request])-1&","&DAY([Date Of Request])&");"&" var Days=Math.round((SPday.getTime()-new Date().getTime())/86400000);"&" this.parentNode.innerHTML=Math.abs(Days)+' days '+((Days<0)?'past':'left');"&"}"">","=[Days taken]")
[Days of Days]是我计算的一列:[发送日期] - [请求日期]
[Days taken] is a column which I calculate: [Date Sent] - [Date Of Request]
如果上述情况属实,则会相应地计算日期,但如果为假,则显示文本"= [天数]" ;。
If above is true, it will calculate the date accordingly, but when it's false, it shows the text "=[Days taken]".
我希望它能显示数字instea文本的d。请帮忙!谢谢!
I want it to show the number instead of the text. Please help! thanks!
推荐答案
嗨Rijia,
Hi Rijia,
您可以更改"= [天数]"至[所用日期]并再次检查。
You can change "=[Days taken]" to [Days taken] and check again.
祝你好运,
Grace Wang
Grace Wang
这篇关于复制另一列中不起作用的值(在IF函数内)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!